If b1 is between x and y value Formula Problem

[tmk0427]

Is it possible to create one formula in one cell, say C15, that is conditioned upon the following:

If C8 is less than or equal to 30,000 then C15 * .06,
If C8 is between 30,001 and 39,999 then C15 * .08,
If C8 is between 40,001 and 49,999 then C15 * .10,
If C8 is greater than 50,000 then C15 * .12

Please advise.

Thanks.

 

[GorD]

Do you mean C8 times the values given or C15?

Easy if you mean C8 circular reference if you use C15 though

 

[tmk0427]

C8 sorry.

 

[GorD]

Try

=if(c8<=30000,c8*.06,if(c8<40000,c8*.08,if(c8<50000,c8*0.1,if(c8>=50000,c8*0.12))))

Hvae used >= for 50000 value as otherwise 50000 wouldn't be covered by any condition

 

[tmk0427]

That worked. Thanks.