Forum Discussion
Multiple Nested IF functions if cells are blank
Hello, I am trying to return 3 different conditions/status based on the value of 3 different cells. I have 3 blank cells in excel and i want the status to change based on values being enter...
As variant
=IFNA(LOOKUP(2,1/(A1:C1<>""),{"New Request","In Progress","Complete"}),"no status")