| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to increase price by % and rounding up and down | Excel Discussion (Misc queries) | |||
| Price calculation - rounding | Excel Discussion (Misc queries) | |||
| Can I automaticly figure "cost" and sale price in Excel? | Excel Worksheet Functions | |||
| Setting up a price list | Excel Worksheet Functions | |||
| formula for cost as percentage of sale price | New Users to Excel | |||
Linear Mode
