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

Need help on formula
 

One way, try:
=IF(ISTEXT(D6),"",IF(D6=40,"Pass",IF(D6=1,"Fail" ,IF(D6=0,""))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Param" wrote in message
...
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

Need help on formula
 

I would probably write the formual differently because this is
longwinded, but - is text , check it is a number in your logic

try

=IF(AND(ISNUMBER(D6),D6=40),"Pass",IF(AND(ISNUMBE R(D6),D6=1),"Fail",""))

Perhaps

=IF(D6="-","",IF(D6=40,"Pass","Fail"))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=518137

Need help on formula
 

type0 instead of-
--
paul
remove nospam for email addy!



"Param" wrote:

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