Rounding Formula

[dkflameboy]

Dear All,

I have the following formula that needs to ROUND the resulting sum.

When I try to ROUND it i get the error "you've entered too few arguments for this function" and I can't figure out where I need to include the ROUND function.

=(SUM((((C13+D13+E13+F13)/2)+B13)/2))

Please help.

Many thanks

 

[Joe4]

First off, you don't use SUM and + on the same range, that is redundant!
Use one or the other, i.e.

SUM(C13:F13)

or

(C13+D13+E13+F13)

but NOT both (like this):

SUM(C13+D13+E13+F13)

With the ROUND function, there are two arguments - what you want to ROUND, and how many decimal places that you want to round it to (see: https://www.techonthenet.com/excel/formulas/round.php)

So if you have a calculation that you want to round, it would be of the structure (this example rounds to 2 decimal places):

=ROUND(calculation,2)

 

[steve the fish]

Heres a slightly shorter way of writing your formula:

=ROUND(SUM(B13*2,C13:F13)/4,2)

 

[dkflameboy]

Brilliant, thanks for the tip and for your help.

 

[dkflameboy]

Thank you.