Thread: Round amount to nearest $10 after other formula calc. in same cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
debtors
 
Posts: n/a
Default Round amount to nearest $10 after other formula calc. in same cell
Cell A1 contains any number, say $2,882. Cell A2 contains a formula to
calculate 10% of cell A1 (result $288.2). How do I round up cell A2 to the
nearest $10 (result $290.00? I do not want to use another cell to calculate
the rounding, it has to be in cell A2.
Reply With QuoteReply With Quote