Setting a sale price and rounding up
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
"Chris" wrote:
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.
|