blanks

  • Thread starter Thread starter ZED
  • Start date Start date
Z

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


.
Click to expand...
 
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
 
Back
Top