ROUND UP COLUMN TOTAL OFF

L

leslie

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba GOAL SEEK 1
sum totals in excel 4
News CES 2019 round up 6
Round Off 2
Using sum on a column I am getting ### instead of a total 4
Formula 2
IF statements 4
Arch Wins 10

Top