SOLVED

help with my excel code please

New Contributor

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","""")

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@michelleV7777 

=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.

Many thanks......that is exactly what I needed.