Forum Discussion

ghaffarhunzai's avatar
ghaffarhunzai
Copper Contributor
Mar 27, 2019

IF AND ELSE Together

Dear All,

 

Please see the above table. The left part is a sample extracted from a survey for checking the status of land among owners.  I need to create a formula which should create the result based on the criteria mentioned on the right side of this table? please help

 

Something like this If (a>0) and (a<1), value, else if, (a>2 and (a<3),value

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 27, 2019

    ghaffarhunzai , that could be nested IF

    =IF(A>3,"",IF(A>2,value3,IF(A>1,value2, value1)))

    Didn't catch what figures in your table exactly mean

Resources