IFBLANK formula but with specific text as well

[Jyggalag]

Hi all!

I have this formula:

But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell.

Can anybody please help?

Thanks!

BR.
Jyggalag

 

[jtakw]

Hi,

Try this instead:

=IF(OR(A63="",A63=1),"","Not Blank and not 1")

 

[Jyggalag]

Hi,

Try this instead:

=IF(OR(A63="",A63=1),"","Not Blank and not 1")

Amazing! It worked

Thank you so much jtakw!

 

[jtakw]

You're welcome, thanks for the feedback.