Operator for Contains

[Leanne M (Aussie)]

Hi,

I want to do a standard IF function - with a twist.

Basically I want to look at a cell and if it is not a whole number then I
want a certain action and if it is then another action.

I thought I could do this with an IF contains . but this does not seem to
work.

Could anyone please provide some help on this topic.

Thanks

 

[Stefi]

Try this:
=IF(MOD(A1,1)=0,"integer","non-integer")

Regards,
Stefi

„Leanne M (Aussie)†ezt írta:

 

[Alan Moseley]

Lets assume that the cell you are checking the number in is in A1. Your
formula should be something like:-

=IF(A1=INT(A1),"Whole Number","Decimal Number")