Share via

Can you use Excel statements IFS and AND together?

Anonymous
2022-08-17T22:03:15+00:00

I have a complex IF statement that I need assistance with. I need to combine the following into logic for one cell. I was going to try using IFS but I haven't been able to make IFS AND work together:

=IF(AND(G14<=2,L14<=2),"Quadrant 3")

=IF(AND(G14<=2,L14<=4),"Quadrant 2")

=IF(AND(G14<=4,L14<=2),"Quadrant 4")

=IF(AND(G14<=4,L<=4),"Quadrant 1")

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-18T15:57:37+00:00

    I believe this worked! Thank you so much!

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-18T05:50:26+00:00

    Hi BSims21,

    Try this formula:

    =IF((G14<=2)*(L14<=2),"Quadrant 3", IF((G14<=2)*(L14<=4),"Quadrant 2", IF((G14<=4)*(L14<=2),"Quadrant 4", IF((G14<=4)*(L14<=4),"Quadrant 1","doesn't exist"))))

    If criteria are not met, then formula return doesn't exist. You can change it, if you want.

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2022-08-18T00:13:16+00:00

    Hi,

    Try this

    =if(G14<=2,if(L14<=2,"Quadrant 3","Quadrant 4"),if(L14<=2,"Quadrant 4","Quadrant 1"))

    0 comments
  5. Anonymous
    2022-08-17T22:37:43+00:00

    Hi BSims21,

    Thank you for posting your query. My name is Clarence, I'll be more than happy to assist you with your concern.

    To resolve your query kindly do the steps below.

    Use the IF function along with AND, OR and NOT to perform multiple evaluations if conditions are True or False.

    Syntax

    IF(AND()) - IF(AND(logical1, [logical2], ...), value_if_true, [value_if_false]))

    IF(OR()) - IF(OR(logical1, [logical2], ...), value_if_true, [value_if_false]))

    IF(NOT()) - IF(NOT(logical1), value_if_true, [value_if_false]))

    Go to this link for your reference and other troubleshooting procedures https://support.microsoft.com/help/d895f58c-b36c-419e-b1f2-5c193a236d97

    Do not hesitate to message us if you need further assistance.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Best Regards, Clarence

    0 comments