Hello, the following formula is working, partially. I have switched it around and tried other methods, seems so simple, but I believe I am making it more complicated, please help and thank you in advance!
The formula needed is: If cell C3 is equal to 1, then return blank and formula needs to go no further, but if not, then if range C3:F3 are all blank, then return the value in H2 and if not, then if cells D3 or E3 are equal to 1, then return the value in cell H2, if none of these apply, then return, " Needs Attention"
This is one of the formulas I have used.
IF(ISBLANK(C3:F3),H2,IF(OR(D3=1,E3=1),H2,IF(C3=1,"","NeedsAttention")))
The formula needed is: If cell C3 is equal to 1, then return blank and formula needs to go no further, but if not, then if range C3:F3 are all blank, then return the value in H2 and if not, then if cells D3 or E3 are equal to 1, then return the value in cell H2, if none of these apply, then return, " Needs Attention"
This is one of the formulas I have used.
IF(ISBLANK(C3:F3),H2,IF(OR(D3=1,E3=1),H2,IF(C3=1,"","NeedsAttention")))