View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_618_] Rick Rothstein \(MVP - VB\)[_618_] is offline
external usenet poster
 
Posts: 1
Default Rounding to nearest 9

You didn't say what you wanted to happen for values above the "9 value"
but less than the "0 value"; for example, what do you want $3249.50 to
"round" to?

Depending on your answer to my question, this formula **may** do what you
want...

=10*ROUNDUP((A1+(MOD(A1,10)=0))/10,0)-1


Of course you will want to replace my A1 references with (E5+G5)*1.25.

Rick