=IF(OR(ISNA) | Problem

[sgm1945]

In column J, I would have numbers ranging from 0 to 999, or #N/A (the cell is not a text #N/A, but a formula).

I need an excel formula that would produce Submit if the value in column J is #N/A or greater than 9. Else it would produce Hide.

The formula I am using -- If the value in column J is greater than 9, it will produce Submit, else it would produce Hide. But if there is an #N/A, it doesnt produce Submit, it would produce #N/A.

=IF(OR(ISNA(J2),J2>9), "Submit", "Hide")

How would I fix my code?

 

[Peter_SSs]

Try

=IF(ISNA(J2),"Submit",IF(J2>9,"Submit","Hide"))

 

[sgm1945]

Try

=IF(ISNA(J2),"Submit",IF(J2>9,"Submit","Hide"))

Thanks! It works perfectly.

 

[Peter_SSs]

Thanks! It works perfectly.

You are welcome.