Trying to have one cell with multiple "if" formulas

[trident3017]

I need help writing a formula for cell G12 that has different "If" statements that modify what is populated into G12
The table below shows the different values that I want to populate into cell G12 depending on the value of cell G7

Sales Multipliers
0% -0.51% OR FURTHER BELOW TARGET
0.40% -0.01% TO -0.50% BELOW TARGET
0.60% AT TARGET TO .49% GREATER THAN TARGET
0.80% .50% TO .99% GREATER THAN TARGET
1.00% 1.00% TO 1.50% GREATER THAN TARGET

I want G12 to = 0% if the value of G7 is <-0.51%
I want G12 to = 0.40% if the value of G7 is <-1.00%
I want G12 to = 0.60% if the value of G7 is <0.50% but greater than 0.00%
I want G12 to = 0.80% if the value of G7 is <1.00% but greater than 0.51%
I want G12 to = 1.00% if the value of G7 is >=1.00%

Thank you for your help!

[MarvinP]

Hi trident and welcome to the forum,

These type of problems can be easier if you use a VLookup formula with a TRUE as the 4th argument.

Watch: https://www.youtube.com/watch?v=tqwMuO8QP28

The second example is closer to what you need to learn.

[Chandrajit]

Trident,
This formula should give you the result.
=IF(D38<1,IF(D38<0.5,IF(D38<0,IF(D38<-1,0.4,0),0.6),0.8),1)
however your question is silent on -0.5 to 0, hence this formula will give 0 for such values