# If b1 is between x and y value Formula Problem

#### tmk0427

##### Board Regular
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

Thanks.

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### GorD

##### Well-known Member
Do you mean C8 times the values given or C15?

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

C8 sorry.

#### GorD

##### Well-known Member
Try

Code:
``=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

##### Board Regular
That worked. Thanks.

Replies
3
Views
179
Replies
5
Views
420
Replies
4
Views
248
Replies
5
Views
268
Replies
6
Views
714

1,171,585
Messages
5,876,309
Members
433,193
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back