Apr 17 2019 03:00 PM
Hi,
I am building an excel spreadsheet and I need help putting together a formula that allows me to choose a $ amount based on a % range. let me explain:
I need the formula to look at a cell, let say E37, and based on the % number in that cell, to determine the associated $ amount:
- if E37is LESS than 5% (cell D46), then $ amount should be the amount located in cell G46
- if E37 is BETWEEN 5% and 9.99% (cell D47), then the $ amount should be the number located in cell G47
- if E37 is BETWEEN 10% and 15% (cell D48), then the $ amount should be the number located in cell G48
- if E37 is MORE than 15% (cell D49), then the $ amount should be the number located in cell G49.
Does anyone know how to write such a formula? I tried using a multiple 'IF" formula but I cant get it to work...
thanks
Apr 17 2019 03:08 PM
Solution@AGuillot, that's like
=LOOKUP(E37,$D$46:$D$49,$G$46:$G$49)
if only you change D49 from 15% on 15.0000001% or so.
Apr 17 2019 03:19 PM
@Sergei BaklanThat worked. awesome! Thankyou Sergei!!!!
Apr 17 2019 03:08 PM
Solution@AGuillot, that's like
=LOOKUP(E37,$D$46:$D$49,$G$46:$G$49)
if only you change D49 from 15% on 15.0000001% or so.