Mar 18 2022 12:36 PM
can someone please tell me what's wrong with my formula. I also don't understand why it wants to put the * in the formula
=IF(OR(AND(C3="Paarl",H3=2014),"right","")*(AND(C3="Wellington",G3>70)),"right","""")
Mar 18 2022 01:02 PM
Solution=IF(OR(AND(C3="Paarl",H3=2014),AND(C3="Wellington",G3>70)),"right","")
Maybe like this if i correctly understand what you want to do.
Mar 19 2022 10:20 AM
Jun 16 2022 05:39 PM
Mar 18 2022 01:02 PM
Solution=IF(OR(AND(C3="Paarl",H3=2014),AND(C3="Wellington",G3>70)),"right","")
Maybe like this if i correctly understand what you want to do.