Forum Discussion
Multiple IF function shows parse error
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
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
