Setting a sale price and rounding up
 

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.

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.

Setting a sale price and rounding up
 

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.

Setting a sale price and rounding up
 

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.

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.