can you nested sum and round function within if function?
Thank you very simply and easy
"Harlan Grove" wrote:
anna wrote...
ypu mean decrese decimal places on the first plaece?
"Don Guillett" wrote:
why not just use the round to start with?
....
"anna" wrote in message
....
up or down I tried to use if function If (sum B2:B25) integer, round
....
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.
|