Message "problem with formula"




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 type a formula and it is as below.  The formula worked until I added AND(e2="GEXPBOOK" and after.  Any idea what I am doing wrong in this formula?

IF(AND(E2="G1LINE",D2>212000),"G>1CARTON",(AND(E2="GEXPBOOK",D2<1000000),"GEXPCARTON",(AND(E2="GEXPBOOK",D2>1000000),"GEXPPAL"," ")

1 Reply


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