• 414K Members
• 6,355 Online
• 479K 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
Highlighted
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.

# Re: Excel formula help

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

# Re: Excel formula help

@AGuillot , you are welcome

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