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.
round up to nearest dollar amount.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
A
Anthony
Sorry typo,
in C1 place =ROUND(B1,0) - this round the number
in C1 place =ROUND(B1,0) - this round the number
C
Chris
Thanks, that worked perfect!
Anthony said:Sorry typo,
in C1 place =ROUND(B1,0) - this round the number
G
Gord Dibben
All in B1
=ROUND(A1*(1-15%),0)
Gord Dibben MS Excel MVP
=ROUND(A1*(1-15%),0)
Gord Dibben MS Excel MVP