SOLVED

Excel formula help

Copper Contributor

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

3 Replies
best response confirmed by AGuillot (Copper Contributor)
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.

 

@Sergei BaklanThat worked. awesome! Thankyou Sergei!!!!

@AGuillot , you are welcome

1 best response

Accepted Solutions
best response confirmed by AGuillot (Copper Contributor)
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.

 

View solution in original post