Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas for rounding
Please can you help.
I have a row of figures in excel spreadsheet and they do not add up to zero (they should add up to zero) Please could you let me know whether there is formula that can check the total and if the row of figures do not add to zero then it puts adds the total figure to a figure in the row to make the total equal zero i.e rounding. Thanks. Mas |
#2
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/pennyoff.html In article , Mas wrote: Please can you help. I have a row of figures in excel spreadsheet and they do not add up to zero (they should add up to zero) Please could you let me know whether there is formula that can check the total and if the row of figures do not add to zero then it puts adds the total figure to a figure in the row to make the total equal zero i.e rounding. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |