blanks

[ZED]

i am makeing a worksheet that needs to calculate scores
200 or under is a pass over 200 is a fail and i want
blanks left blank. the fornula i used has the blanks
comeing up as fails.
this is the formula i used

IF(AND(N100<=200, N100>1),"PASS","FAIL"

 

[Frank Kabel]

Hi
try
=IF(N100="","",IF(AND(N100<=200, N100>1),"PASS","FAIL"))

 

[Ragdyer]

Try this:
=IF(NOT(ISNUMBER(N100)),"",IF(AND(N100<=200, N100>1),"PASS","FAIL"))

 

[Guest]

thakyou very much that did the job

-----Original Message-----
Hi
try
=IF(N100="","",IF(AND(N100<=200, N100>1),"PASS","FAIL"))

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Michael]

Hi Zed or Patrick
Firstly, one post will get our attention, more than that
will annoy the hell out of everybody.

Try the following formula:

=IF(ISBLANK(N100),"",IF(AND
(N100<=200,N100>1),"PASS","FAIL"))

Regards
Michael