If function based on multiple columns
I have done formula on column 3 and 4
if column 3 returns yes and column 4 is blank, the status will return from column 3
but if column 4 has yes in it, the status will return from column 4 ignoring what is column 3
I want to add the column 5 in the same formula with the same principle
if column 5 has yes, status will be yes, otherwise it will look at the column on the left
if column 4 is blank it will look at column 3
@Paul Newcome @Genevieve P. i have tagged you guys hoping you can help directly please
would really appreciate your advise
Best Answer

It's easiest and cleanest to write the formula backwards (in this case, from the rightmost to the leftmost). Try this:
=IF([Column5]@row = "Yes", "C Approved", IF([Column4]@row = "Yes", "B Approved", IF([Column3]@row = "Yes", "A Approved")))
Hope this helps!
Answers

It's easiest and cleanest to write the formula backwards (in this case, from the rightmost to the leftmost). Try this:
=IF([Column5]@row = "Yes", "C Approved", IF([Column4]@row = "Yes", "B Approved", IF([Column3]@row = "Yes", "A Approved")))
Hope this helps!

@Kelly P. Thank you Kelly, this was much simpler than I thought!
Much appreciated.

Happy to help!! 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!