each rows has different conditions, in a single cell ?

kumars23

each row has different conditions, In a single cell  I need to enter all the formulas for different levels of each row? please help me. Thanks in advance.

MichaelTCA

Hello @kumars23

Try this. It will look at different criteria for similar results.

=IF(OR(AND(Level@row = "Level 3", OK@row = 5),AND(Level@row = "Level 1", OK@row = 3)),"Closed","")

You can also use nested If functions like you have, but your syntax is incorrect.