Forum Discussion
Message "problem with formula"
Hi, i have typed an if and formula but im getting error message stating "Theres a problem with this formula...not trying to type a formula? when the first character is an equal.." I am trying to ...
=IF(AND(E2="G1LINE",D2>212000),"G>1CARTON",IF(AND(E2="GEXPBOOK",D2<1000000),"GEXPCARTON",IF(AND(E2="GEXPBOOK",D2>1000000),"GEXPPAL"," ")))
You can try this formula which works in my sheet.