can you nested sum and round function within if function?

A

anna

Can you please tell how to sum one column of data and at the same time round
up or down I tried to use if function If (sum B2:B25) >integer, round
(sumB2:B25, 0),sum((B2:B25) but it does not work excel does not recognize the
text in that case
 
H

Harlan Grove

anna wrote...
ypu mean decrese decimal places on the first plaece?
Click to expand...
....

I'd guess Don meant why not use

=ROUND(SUM(B2:B25),0)

which would be the same as SUM(B2:B25) if that sum is a whole number
and rounded to the nearest integer otherwise.
 
A

anna

Thank you very simply and easy

Harlan Grove said:
anna wrote...
....

I'd guess Don meant why not use

=ROUND(SUM(B2:B25),0)

which would be the same as SUM(B2:B25) if that sum is a whole number
and rounded to the nearest integer otherwise.
Click to expand...
 
Top