Multiple Conditions

[cfieser]

Hi!

I am trying to create a formula that tests two cells for conditions and produces a result, but I am having issues with my formula.


This is the formula I created that I am having trouble with:


=IF(AND($C6=4,$F6=100-104.9),500,0)


Here are a few of the scenerios I am working with.


If the cell in C = 4 and the cell in F = 100%-104.9% the result should be 500


If the cell in C = 4 and the cell in F = 105%-114.9% the result should be 1250


If the cell in C = 4 and the cell in F = 115% and greater the result should be 5000


Thank you!

 

[Hui]

I would use a formula like:

=IFERROR(IF($C6=4,VLOOKUP(F6,M2:N4,2)),0)

where M2:N4 is


1.00 500

1.05 1250

1.15 5000