Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ROUND UP COLUMN TOTAL OFF
I have a column that the formula in the cell is =ROUND(G4,2) but when I try
to total G4 to G46 it does not use the round figure total? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ROUND UP COLUMN TOTAL OFF
You have numbers in G4:G46 and in another column you have formulas like
=ROUND(G4,2) Let these be in H4 down to H46 In H47 =SUM(H4:H46) will sum the rounded values. It could be formatted to show more decimals but these all all be zeros (after the second place) Please tell us where this goes wrong -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "leslie" wrote in message ... I have a column that the formula in the cell is =ROUND(G4,2) but when I try to total G4 to G46 it does not use the round figure total? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
disable Total and/or Sub total for a single column | Excel Worksheet Functions | |||
Round Total | New Users to Excel | |||
Round to Thousands and x-foot the sum of the total | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |