If Blank in formula Help!

christy_720

IF IS BLANK.jpg

I have setup a formula =IF(AND([WO # if applicable]@row = "N/A"), "No", "Yes") in a Notify Process Docs column, that when a N/A is entered into the WO # if applicable column returns a No value. Any other value will return it to Yes, triggering a notification to be sent to certain individuals. I am struggling on the formula to return a "No" value if the cell is blank.

Thank you in advance for your assistance.

Paul Newcome

Try this:

=IF(OR([WO # if applicable]@row = "N/A", [WO # if applicable]@row = ""), "No", "Yes")

Paul Newcome

Try this:

=IF(OR([WO # if applicable]@row = "N/A", [WO # if applicable]@row = ""), "No", "Yes")

christy_720

That worked! Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️