IF AND ELSE Together

Occasional Visitor

survey.JPGDear 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

1 Reply

@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