Forum Discussion
Multiple IF function shows parse error
=if(F4=5,if(G4="success",if(H4=10,if(I4>=20,if(k4=>200,if(l4="yes",if(m4=>2,if(n4=>3,if(o4=>2, if(p4=>2,if(q4=>1,if(r4="success",if(s4="yes",if(t4="yes",if(u4="yes",if(V4>=100,"Great Day","Work hard"))))))))))))))))
Plz help me...
Dear nisamudheenvm87,
Use the below formula and recheck your result.
=IF(AND(F4=5,G4="success",H4=10,I4>=20,K4>=200,L4="yes",M4>=2,N4>=3,O4>=2,P4>=2,Q4>=1,R4="success",S4="yes",T4="yes",U4="yes",V4>=100),"Great Day","Work hard")
You have also mentioned that
negative result shows FALSE... especially in " "
I have not understood this statement. Kindly elaborate.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
6 Replies
- On advice now changed like this.. =if(F4=5,if(G4="success",if(H4=10,if(I4>=20,if(K4>=200,if(L4="yes",if(M4>=2,if(N4>=3,if(O4>=2, if(P4>=2,if(Q4>=1,if(R4="success",if(S4="yes",if(T4="yes",if(U4="yes",if(V4>=100,"Great Day","Work hard"),))))))))))))))) But negative result shows FALSE... especially in " "
Dear nisamudheenvm87,
Use the below formula and recheck your result.
=IF(AND(F4=5,G4="success",H4=10,I4>=20,K4>=200,L4="yes",M4>=2,N4>=3,O4>=2,P4>=2,Q4>=1,R4="success",S4="yes",T4="yes",U4="yes",V4>=100),"Great Day","Work hard")
You have also mentioned that
negative result shows FALSE... especially in " "
I have not understood this statement. Kindly elaborate.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
- To put this in simple words, if all of your conditions are true, then you output "Great Day". Since the AND function is used, even if one of the conditions is not met,then this will output "Work Hard".
