View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue
 
Posts: n/a
Default Rounding and Multiplying

Can I multiply 2 numbers together and have the answer rounded to 0 decimals?

For example:

a1 = 4.25
b1 = 5.25
c1 = 22.31

I want c1 to be rounded to 22 (not just formatted to look like 22 but to
actually round the number).

Thanks,
--
Sue