CODEWITHSUNDEEP
excelfunctionif-statement
Piyush Bhattacharya
Piyush Bhattacharya

Reputation: 63

Using AND and OR clauses together in MS Excel IF function

I have a table as below:

Area  Owner/Tenant   Rent
----  ------------   -----
450        O         {IF..}
900        V
350        T
600        T

Conditions to be used: 

1. If (Area <= 450) AND (owner/tenant = "O" OR "V"):
   True: 1330
   False: 1440
Formula: =IF(AND(D18<=450,OR(F18="O",F18="V")),1330,1450)



    

  1. IF (Area > 450) AND (owner/tenant = "O" OR "V"):
True: 1550
False: 1660
Formula: =IF(AND(D18>450,OR(F18="O",F18="V")),1550,1660)

I have been able to evaluate the two conditions above with individual IF formula. However, I am not able to combine the two formulae into a single formula that I would like to apply to the "Rent" column.

Can somebody please help?

BR, Piyush

Upvotes: 1

Views: 262

Answers (1)

Nicholas Flees
Nicholas Flees

Reputation: 1953

I'm making some assumptions here about what you want to happen, specifically what should happen based on which side of the AND statement causes it to evaluate to false, but I think I understand. I would use the following formula:

=IF(D18<=450,IF(OR(F18="O",F18="V"),1330,1450),IF(OR(F18="O",F18="V"),1550,1660))

This is embedding an additional conditional in your THEN and ELSE clauses.

Upvotes: 1

Related Questions