Excel Multiple Conditions Formula

Copper Contributor



Hoping for some help with the below query:


There are 2 different categories and 5 options in each. These options combined determine the answer in a separate cell.



B2 = 1 or 2 or 3 or 4 or 5

B3 = 0.1 or 0.2 or 0.3 or 0.4 or 0.5

IF B2=1 and B3=0.1 then B4=2020

IF B2=2 and B3=0.5 then B4=2021


There is no correlation between the numbers in B2 and B3 but the answer in B4 is predefined based on the options selected in the 2 categories.


It appears B4 requires multiple IF formulas in the same cell but not sure how to write this correctly.


Please help!

2 Replies
best response confirmed by Kong08 (Copper Contributor)



You can try this formula for the data layout of the example.

multiple condition formula.JPG 

Thank you!!!