SOLVED
Home

Excel formula help

AGuillot
New 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
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.

 

Highlighted

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

@AGuillot , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies