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
- 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".
- Thanks... solved
How did you resolve this? I have a similar issue:
=IF(C27="NOT APPLICABLE",0,IF(C27="NOT LIKELY",1),IF(C27="SOMEWHAT LIKELY",2),IF(C27="HIGHLY LIKELY",3))
Maybe there is a different function and nested IF is not the right one? Or maybe I have misplaced parentheses? Can you help since you solved this for yourself already? -- Claudia
=IF(C27="NOT APPLICABLE",0,IF(C27="NOT LIKELY",1,IF(C27="SOMEWHAT LIKELY",2,IF(C27="HIGHLY LIKELY",3,""))))
