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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies