Display IF AND/OR is met

[jmazorra]

Hello folks:

With the following formula in cell N46 =IF(M46="N/A","",IF(M46>=0.014,"Yes","No"))

I want to add that if M46 is blank or N/A then return blank. I have tried adding and OR statement, but it is not working, any help will be necessary.


Thanks

 

[pplstuff]

=IF(or(M46="N/A",isblank(m46)),"",IF(M46>=0.014,"Yes","No"))

Also, are you sure you mean "n/a" as opposed to na()?

 

[pplstuff]

Sorry for double post, also note isblank() means a truly empty cell. You could change isblank(m46) to m46="" depending on what you mean.

 

[jmazorra]

Thanks for the solution, exactly what I needed