M

#### moily

I'm using Excel 2003 and am interested in knowing a forumla that can

identify decimal numbers versus whole numbers. I need to create an if

forumla that says YES if it's a decimal (ends in .5) and NO if it's a whole

number. Details below:

I have a cell that can be input with only whole numbers

(1.00,2.00,3.00,4.00,5.00, to max of 31) or numbers that end in .5 (0.50,

1.50, 2.50, 3.50, 4.50, 5.50, to max of 30.5) but the decimals will always

only end in .5 (no other decimal points).

I've had difficulty using wildcards with numbers: ie:

if(a1="*"&.5,"YES","NO") or if(a1="*"&".5","YES","NO"). One of the problems

is that Excel automatically puts a 0 in front of the decimal point if it's

not in quotes but it could be any number up to 30 in front of the decimal

point. However, I can't put it in quotes I assume because it's a number, not

text (I've tried it anyway and it still doesn't work).

Thanks in advance for any help!

Best,

Ann