| 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 | |||
Linear Mode
