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
you can use lookup here. however you need to get the top value of the range first.
so you will get the top limit. Then:
this formula will get the closest result lower than the upper limit if it can not find an exact value.