If function based on multiple columns

MazU

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

Kelly P.

@Maz Uddin

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.

@Maz Uddin

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!

MazU

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

Much appreciated.

Kelly P.

@Maz Uddin

Happy to help!! 🙂