| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Threaded Mode
