Mar 27 2019 03:31 AM
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
Mar 27 2019 03:45 AM
@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