Forum Discussion

nisamudheenvm87's avatar
nisamudheenvm87
Copper Contributor
May 10, 2017
Solved

Multiple IF function shows parse error

What is the parse error with this formula.. =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",...
Excel on mobile
Formulas & Functions
  • vijaykumar shetye's avatar
    vijaykumar shetye
    May 10, 2017

    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

Claudia Dubaldi's avatar
Claudia Dubaldi
Copper Contributor
May 31, 2018

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 31, 2018
=IF(C27="NOT APPLICABLE",0,IF(C27="NOT LIKELY",1,IF(C27="SOMEWHAT LIKELY",2,IF(C27="HIGHLY LIKELY",3,""))))

Resources