If the result of a calc is a decimal rounddown to whole #!!!!

[Guest]

Why is this so hard to do... i do not want to round to the nearest .95 or .99
or dates and so on and so forth. I have searched and searched. Arggg!

I have a calculation that I want rounded. The formula has an IF statement
in it.
=IF(Q12=0,"",(Q12/50)) If this results in a a decimal number .. like 0.2 or
0.9 I want it rounded DOWN to the nearest whole number. I have looked high
and low.. online, in help and many trial and errors . ??

any one who knows this?

Thanks

 

[JE McGimpsey]

One way:

=IF(Q12=0,"",INT(Q1/50))

or:

=IF(Q12=0,"",ROUNDDOWN(Q1/50,0))

or:

=IF(Q12=0,"",TRUNC(Q1/50))

or:

=IF(Q12=0,"",FLOOR(Q1/50,1))


Note that TRUNC and INT act the same for non-negative numbers, but
opposite for negatives. See Help for details.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html