a bit hard to help without the fuctions you are using.

But trying the ISBLANK() and ISNUMBER() functions.

I put an example you can look at:

=IF(ISBLANK(A1),"blank", IF(ISNUMBER(A1), IF(A1=0, "0 is the score", A1
& " is the score"), "Nonnumeric entry detected"))

So to break it down, it first check to see

is A1 blank?

if yes, display the word "blank"
If no then find out if A1 is a number?

If yes, is A1 a 0?
If no display Nonnumeric entry detected

If A1 is a 0, display 0 is the score,
If A1 is a number and higher than 0, display the number as the score

I put it all together so that you can see how each part works. If you
have any more questions, don't hesitate to ask


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550025