Forum Discussion
michelleV7777
Mar 18, 2022Copper Contributor
help with my excel code please
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)),"rig...
- Mar 18, 2022
=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.
OliverScheurich
Mar 18, 2022Gold Contributor
=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.
artemkhorew
Jun 16, 2022Copper Contributor
Hi! PLS check my question: https://techcommunity.microsoft.com/t5/excel/please-help-me-with-formula-in-excel/m-p/3518804