Forum Discussion
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 resul...
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