Add a column with formulas
 

I have the following formula in a cell =A4*$A$1 and when I try to sum the
column and maker it to 2 decimal places it rounds my total down and so I get
the incorrect total. What do I need to add to the formula so it will not
round?

Add a column with formulas
 

Make the formula

=round(A4*$A$1, 2)



"Trevea" wrote:

I have the following formula in a cell =A4*$A$1 and when I try to sum the
column and maker it to 2 decimal places it rounds my total down and so I get
the incorrect total. What do I need to add to the formula so it will not
round?