View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default rounding the answer of a formula

one way:

=ROUNDUP(38/12,2)

In article ,
"Boze" wrote:

I want to divide one number by another and round the answer up to the
nearest hundreth.
Ie, 38 inches divided by 12 equals 3.17.
Right now I can DISPLAY the 3.17 but when using that in a formula it's
calculating with 3.1667

Thanks in advance
Boze