if/and then, with multiple criteria

[paula.mccall]

Good afternoon,

I am trying to create a formula that will return a specific dollar amount if certain criteria are met.
Example:

If A2 = 1 and B2 = 1, then C2 = $0.085
If A2 = 1 and B2 = 2, then C2 = $0.175
If A2 = 2 and B2 = 1, then C2 = $0.110
If A2 = 2 and B2 = 2, then C2 = $0.200

Would someone be able to provide me a formula that would work for these conditions?

I greatly appreciate your time and help!

Kindest Regards,

Paula

[jeffreybrown]

Hi Paula,

How about...

=IF(AND(A2=1,B2=1),0.085,IF(AND(A1=1,B2=2),0.175,IF(AND(A1=2,B2=1),0.11,IF(AND(A1=2,B2=2),0.2))))

If you have more than these four criteria, this would get awfully long, so maybe another solution could work.

[paula.mccall]

hello Jeff,

That was all the criteria I had and the formula works perfectly.
thank you so much for your help!!!!

Kindest Regards,
Paula

[jeffreybrown]

Hi Paula, you're welcome & thanks for the feedback.