Posts by Hannah Gomez5

Walter Jackson48 said:If the base price is in cell A1—assuming your discount is 10% and sales tax is 15%—then just type =(A1-(A1*0.10))*1.15 into cell B1

👍

I assume you meant discount rather than margin...
since a margin would actually imply an increase...

Kyle Johnson2 said:That’s essentially how it works—you always have to manually calculate what number replaces the 0.85 whenever the discount changes 😉

I am... assuming one can mentally figure out 1 minus 0.something

something = the discount percentage

I suppose it's obvious that, say, 15% would be written as 0.15

Nicholas King said:And you could also skip the extra multiplication—just set B1 = 1.0455 * A1

😁

but then... is that number just calculated by hand somewhere else???

Bradley Rivera5 said:I didn't quite get the parentheses right—either way, thanks so much...

It works without them too...

FORMULA IN B1 =0.85*A1*1.23