Setting a sale price and rounding up

C

Chris

I have a wigit that's say $119. I want to take 15% off of that price and then
round up to nearest dollar amount.
 
A

Anthony

hi,

If the price for ur wigit is held in cell A1 (ie $119)
in B1 place =A1*(1-15%) - this takes off the 15%
in C1 place =ROUND(B2,0) - this round the number
not sure how to combine the two entries, but they will give youi the
required result
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I round up to the nearest nickel? 2
rounding decimals to nearest quarter 4
Bargain Ubisoft - up-to 75% off sale 0
Formula Help 1
rounding formulas 2
rounding figures to nearest thousand 3
ROUND CELLS TO NEAREST DOLLAR 4
Rounding up to next dime 2

Top