If Statement Excel Formula

Question

I am trying to create nested if statements with text value options to result a cell value if the conditions are met. For example: If E30="Associates" and E31="High School" return value of cell F34, but if E30="bachelors" and E31="high school" return value of cell F35. If E30="Bachelors" and E31="Associates" return cell value of F36, If E30="masters" and E31="associates" return value of cell F37, If E30="masters and E31="bachelors" return cell value of F38.

Answer 1

Hi respected Paula Dawson65,,

Thanks for your valuable feedback, glad to know that my replies helped you.

I appreciate your kind words.

You are welcome:) You may also give feedback on it( if you find our suggestions helpful), you can also use the feedback tool below our reply to submit your feedback for us (pictured below).

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best wishes

Waqas Muhammad

Answer 2

Thank you very much Waqas Muhammad for the quick reply. The formula worked perfectly.

Answer 3

Dear respected Paula Dawson65,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem but based on your description we can work together to resolve it.

For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description,

=IF(AND(E30="Associates", E31="High School"), F34,IF(AND(E30="Bachelors", E31="High School"), F35,IF(AND(E30="Bachelors", E31="Associates"), F36, IF(AND(E30="Masters", E31="Associates"), F37, IF(AND(E30="Masters", E31="Bachelors"), F38, "")))))

If there is any misunderstanding, I apologize and if possible could you please send copy of your document file to me so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

If there is confidential information, then you can send it to me in Private Message(PM). you can access PM from the top right corner of this page, as shown in image below:

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad