Setting a sale price and rounding up
All in B1
=ROUND(A1*(1-15%),0)
Gord Dibben MS Excel MVP
On Wed, 2 Jul 2008 08:52:01 -0700, Chris
wrote:
Thanks, that worked perfect!
"Anthony" wrote:
Sorry typo,
in C1 place =ROUND(B1,0) - this round the number
"Anthony" wrote:
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.
|