Can you have 2 IF functions in 1?
example:
=IF(AC46=0,"CLOSED",AC46) or =IF(V46=32,"NULL",V46)
Basically if the value equals zero, i want it to say Closed, OR if the value of another cell equals 32 I want it to say Null.
There is no way for both to be true.
Is this possible? Thanks!
example:
=IF(AC46=0,"CLOSED",AC46) or =IF(V46=32,"NULL",V46)
Basically if the value equals zero, i want it to say Closed, OR if the value of another cell equals 32 I want it to say Null.
There is no way for both to be true.
Is this possible? Thanks!