blanks

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: ZED (anonymous_at_discussions.microsoft.com)
Date: 08/12/04 

Date: Wed, 11 Aug 2004 21:52:32 -0700

i am makeing a work*** 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"

Quantcast