| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add up column of figures to exclude hidden decimal amounts
How do I add up columns of cash figures to exclude the hidden amounts after
the two decimal points for the pence eg on the spread sheet the amount may be shown as £10.35 which is correct but as this has been arrived at from a formular in another coloum it also contains hidden amounts ie it could be £10.3524 so when I do a total of say 500 rows this can make quite a diference to the corect total, all I want to do is add up the actual amount shown on the spread sheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add up column of figures to exclude hidden decimal amounts
Use the ROUND() function
-- Gary''s Student - gsnu200799 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add up column of figures to exclude hidden decimal amounts
On Aug 11, 4:18 am, Gary''s Student
wrote: Use the ROUND() function -- Gary''s Student - gsnu200799 And use it on all the formulas at the end of each row, not on the final total at the bottom. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert Amounts written in figures to words ? | Excel Discussion (Misc queries) | |||
| aligning decimal point in a column of figures in Excel | Excel Worksheet Functions | |||
| Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
| Is there a way to exclude hidden rows/columns when printing a doc | Setting up and Configuration of Excel | |||
| How can I change decimal amounts to end with .95 | Excel Worksheet Functions | |||
Linear Mode
