Forum Discussion
Solved
adding information to nested if formula not working
Hi, Can anyone help me please? I have the following formula IF(B2=3001,"N/A",IF(C2="IN","GEXPBOOK",IF(E2="GDG","GDG",IF(D2=1,"G1LINE",IF(AND(A2>0.01,A2<=53000),"G1CARTON",IF(AND(A2>53000,A2<1000000...
hi i tried using the ifs formula but it didn't return the correct fields such as G1PALLET
That's not because the IFS function doesn't work. You need to define the conditions correctly (i.e., clearly and in keeping with the actual intentions) and in the right sequence. It's very easy to inadvertently be less clear /precise/accurate than intended.
Let me try again to see if I can adapt your nested IF.
Let me try again to see if I can adapt your nested IF.