can you nested sum and round function within if function?

[Guest]

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

 

[Don Guillett]

why not just use the round to start with?

 

[Guest]

ypu mean decrese decimal places on the first plaece?

 

[Harlan Grove]

anna wrote...

ypu mean decrese decimal places on the first plaece?

....

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.

 

[Guest]

Thank you very simply and easy

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.