Operator for Contains

  • Thread starter Thread starter Leanne M (Aussie)
  • Start date Start date
L

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
 
Try this:
=IF(MOD(A1,1)=0,"integer","non-integer")

Regards,
Stefi

„Leanne M (Aussie)†ezt írta:
 
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")
 
Back
Top