View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default 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.