IF and Formula Help

=IF(AND(F3>=N9,F3<=N10),N12,N13),IF(AND(F3>=P9,F3<=P10),P12,P13),IF(AND(F3>=R9,F3<=R10),R12,R13),IF(AND(F3>=T9,F3<=T10),T12,T13)

That is the formula that I am using to try and take a total from a cell, then see if it falls within ranges, and if it doesnt go onto the next until it finds the range which it falls in, then if it does show the result.


Condition 1 0 Condition 1 51 Condition 1 151 Condition 1 1001
Condition 2 50 Condition 2 150 Condition 2 1000 Condition 2 2000

Result If True 10 Result If True 20 Result If True 40 Result If True 70
Result If False 0 Result If False 0 Result If False 0 Result If False 0

See yellow banner on how to attach a sample workbook.

Table in N:P (although Column O not actual required)

in G3

=VLOOKUP($F2,$N$1:$P$4,3,1)

Was my method going to work?

Corrected ....so try and understand why yours would not work .. logic of IF statement

=IF(AND(F4>=$N$9,F4<=$N$10),$N$12,IF(AND(F4>=$P$9,F4<=$P$10),$P$12,IF(AND(F4>=$R$9,F4<=$R$10),$R$12,IF(AND(F4>=$T$9,F4<=$T$10),$T$12,0))))

how would one expand the look up table?

Just add new values and change the range in VLOOKUP

=VLOOKUP($F2,$N$1:$P$4,3,1)