Division of a figure

[gilbert]

Just wonder how we can request Excel to return True when we divide 2 numbers together if it is exact figures (ie.. no decimal points).

[Trebor76]

Hi there,

Say your numbers are in A1 and B1 (change as required), enter the following formula in whatever cell you wish to see the result in:

=IF(TRUNC(A1/B1)=TRUNC(A1/B1,1),"TRUE","FALSE")

HTH

Robert

[gilbert]

Thanks! It works perfectly..... now my formular is working. Thanks for the tips!