View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Param
 
Posts: n/a
Default Need help on formula

I create function to read as:

=IF(D6=40,"Pass",IF(D6=1,"Fail",IF(D6=0,"")))

my question, when I enter mark 40 and above it appear 'Pass" - ok
when I enter below 40 it appear 'Fail' - ok
but if I enter - (still show 'Pass')

how to overcome like when I enter 0 - become blank