Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excell
Can anyone who is an expert on Excell, please help me.
I need advice on adding up on Excell. The normal ADD function adds everything, including, third, fourth and fifth hidden decimal places etc, even though you are only viewing two decimal places. In accounts, when cross checking, the total column adds up differently to the across total, because it has added all the decimal places, but if you add the actual figures shown in the column (two decimal places), the total is different. I know, somewhere there is a way I can get excell to CALCULATE to only two decimal places and not just VIEW two decimal places, but I cannot remember how to do it. Can anyone help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excell to Microsoft Word | Excel Worksheet Functions | |||
Microsoft Excell '97 | Excel Discussion (Misc queries) | |||
how do I download microsoft excell free | Excel Discussion (Misc queries) | |||
MICROSOFT EXCELL (XLS) | New Users to Excel | |||
i have microsoft works spreadsheet not excell, can i upgrade to ex | Excel Discussion (Misc queries) |