Hi,
I'm sure this is pretty basic but I can't figure it out so hope someone can help. I am trying to figure a percent off and then also round the result down in the same cell.
My beginning price is $49.95
To calculate 10% off my formula is =$A2*(1-B1) resulting in $44.96
To round down $44.96 to $49.95 the formula is =ROUND(A2/0.05,0)*0.05
But I can't figure out for the life of me how to combine these two formulas in the same cell.
Help?
Thanks in advance,
Rosanne
Bookmarks