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