multiple conditions required for formula

Hi all, I have used the forum regularly for info, but I am reaching out today for some assistance on a particular issue.

First off, here is the data I am looking at.


User will select either optionA or optionB from a dropdown in column V and then enters a dollar value in column X. Dependant on the choice, there is a matrix:

optionA optionB
LOW HIGH LOW HIGH
0.52 0.54 0.57 0.59

*Under and including LOW: Level 1
*Between LOW and HIGH: Level 2
*Above and including HIGH: Level 3

As examples:
1. User selects optionA at a price of 0.51, it should result in LEVEL1
2. User selects optionB at a price of 0.58, it should result in LEVEL2

Thanks in advance

This should work if those are your only two options. In this formula V2 refers to the "option a" or "option b" dropdown, and X2 refers to the dollar value.

=IF(V2="option a", IF(X2<=0.52, "Level 1", IF(X2>=0.54, "Level 3", "Level 2")), IF(X2<=0.57, "Level 1", IF(X2>=0.59, "Level 3", "Level 2")))

I would need to add the possibility of a blank field. If the field is blank, then the result should also be blank.

Thanks a bunch!