Rounding formula

It has been suggest that I use a round formula in column AM on the attached spreadsheet.

I have never used the Round formula and unsure as how I should write the formula

would it be =round(cells I want it to round, decimel places)

Can I select several cells or does it have to be done one at a time.

The columns that are being added together to get the final total are F4, L3, X3, AD3, AJ3 and R3

Just wrap the ROUND function around

e.g.

=ROUND(AJ2+AD2+X2+R2+L2+F2,0)

where 0 is number of decimal places.

Hi Tracyann,

You need perform a ROUND on each range reference in order to get the number you want.

I.e.

Please Login or Register  to view this content.