IF OR ISBLANK Help!

Lee Wood

Good afternoon,

I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value. The two cells will never both have a value in at the same time, just one or the other.

The cells are as follows:

Unscheduled Downtime Reason

Scheduled Downtime Reason

If both are blank then it should return the word "Online", if either have a value then it will return the value.

Thank you for your help in advance!

Sameer Karkhanis

Try this:

IF(ISBLANK([Unscheduled Downtime Reason]@row),
	IF(ISBLANK([Scheduled Downtime Reason]@row), "Online", [Scheduled Downtime Reason]@row),
	[Unscheduled Downtime Reason]@row
)