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
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

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

Regards,
Stefi

€žLeanne M (Aussie)€� ezt Ã*rta:

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
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

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")

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk


"Leanne M (Aussie)" wrote:

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
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)