View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Rounding to nearest 9

suppose u have result in A1,
try =CEILING(A1,9)

On Jun 5, 10:11*pm, GaryS wrote:
I have the following =(E5+G5) * 1.25 * which results in $1446.25. *I would
like it to be rounded to $1449.00. *How could I do this? *Thanks!
--
Gary in Michigan, USA