IF Function trouble

[Eliana385]

Hello,

I am struggling with this formula in order to have the amount (column D) in the correct bucket (columns G, H, I, J, K, L, M or N) based on the number of days in column F.

I have tried with both IF(AND and IF(OR and cannot get the number in the correct cell.

Anybody can help?

Thanks a lot

[#2]

you can use lookup here. however you need to get the top value of the range first.

=RIGHT(H$1;LEN(H$1)-SEARCH("-";H$1;1))*1

so you will get the top limit. Then:

=LOOKUP(RIGHT(H$1;LEN(H$1)-SEARCH("-";H$1;1))*1;A:A)

this formula will get the closest result lower than the upper limit if it can not find an exact value.