Posts by Bradley Rivera5

Hannah Gomez5 said:you don't actually need those parentheses

The FORMULA in B1 is =0.85*A1*1.23

Thanks for the input, everyone, but I think I’ll stick with my way. That specific formula just works better for me. The base isn't always going to be 10; it shifts around all the time, so I need that flexibility...😉

Kyle Johnson2 said:If you’d actually bothered to look at the second-to-last photo in that second link, you would've spotted the formulas right there.
But honestly, why bother doing the math yourself when you can just let someone else do all the heavy lifting for you? 👎

Let's say you've got the value 10 sitting in cell A1, and you want the result in B1 to be 10.46.
=A1-(A1*0.15)+((A1-(A1*0.15))*0.23)

Man, I totally messed up how I was using the parentheses. Anyway, thanks a ton for the help!!!

Kyle Johnson2 said:Take a look at this, maybe it'll help you out

- A sample of what a full invoice looks like in Excel

- An example showing how to calculate sales tax and discounts

Thanks, but I already checked there and didn't find anything... my situation is pretty specific because I'm just working with two cells—I have the base amount in the left one, and then in the right one, I need the final result from a whole bunch of different operations combined

Hey everyone!
I’d be super grateful if someone could lend me a hand here. I’m struggling to nail down an Excel formula that takes a number, slashes it by 15% for a discount, and then immediately bumps it back up by the sales tax all in one go in the cell right next to it.
So, basically: I have my base price minus the discount plus tax (for example, if I start with 10... I need to end up with 10.46)

Thanks a million!