View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mavy@discussions.microsof is offline
external usenet poster
 
Posts: 12
Default rounding off with links

How do I round off the result of a formula or links of adding the amounts in
different worksheets?

I tried =ROUND((!H15!K15+!L15,0) and
=MROUND((!H15!K15+!L15,0) but it doesn't round off. Is there a possible way
or I just have to manually enter the numbers? I want to round it off to the
nearest 100 or 1000 as well.

Thanks!

--
thank you!
Mavy