using if and isna function

[akshatk1991]

I want to create a function which returns a certain value if one of 3 conditions are met, and #N/A if it is false,

So far my function looks like this, but isnt working properly. If A40 is zero, NA or blank, i want it to return BL12, and if it has a value, then NA.

IF(OR(A40=0,A40="",ISNA(A40)),BL12,NA())

 

[Rick Rothstein]

I want to create a function which returns a certain value if one of 3 conditions are met, and #N/A if it is false,

So far my function looks like this, but isnt working properly. If A40 is zero, NA or blank, i want it to return BL12, and if it has a value, then NA.

IF(OR(A40=0,A40="",ISNA(A40)),BL12,NA())

Describe "isn't working properly"... exactly what is happening that you think should not be happening?