• 412K Members
• 3,403 Online
• 468K Conversations
SOLVED

New Contributor

# Excel formula help

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

# Re: Excel formula help

@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

# Re: Excel formula help

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

# Re: Excel formula help

@AGuillot , you are welcome

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies