#### mikie1881

##### New Member
I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%.

Michell

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### JoeMo

##### MrExcel MVP
Putting a formula in B8 that refers to B8 will create a circular reference. I suspect that's not what you want. Can you explain what you are trying to do?

#### RayFrye

##### Board Regular
JoeMo is correct, your notion will cause a circular reference.

However, you can put this formula (=B8*(B1*0.1)) in C8 (or where ever) and calculate based on B1 and B8.

=B8*(B1*0.1)

#### mikie1881

##### New Member

ok, sorry because i have no experiance in excell. and my english is not good as well so , i have an excell that calculate some values in simple, in B8 there is a value that must be multiplyied with the value on B7 wihch the value ( B7) changes from 1to3 , if is 1 means 10% , 2 means 20% 3 means 30%. , the results goes to cell B9. I hope to be understanding my text. Regards michell

#### JoeMo

##### MrExcel MVP
ok, sorry because i have no experiance in excell. and my english is not good as well so , i have an excell that calculate some values in simple, in B8 there is a value that must be multiplyied with the value on B7 wihch the value ( B7) changes from 1to3 , if is 1 means 10% , 2 means 20% 3 means 30%. , the results goes to cell B9. I hope to be understanding my text. Regards michell
Maybe put this formula in B9:
=(B8*B7*0.1)

#### mikie1881

##### New Member

I Thank you all for your answers ,apreciate a lot. Best Regards Michell

#### Tarver

##### Board Regular
How about this? This formula can't go in cell B1 or B8, but it can go anyplace else.

=IF(B1=1,B8*.1,IF(B1=2,B8*.2,IF(B1=3,B8*.3,"ERROR, B1 isn't 1, 2, or 3.")))

#### mikie1881

##### New Member
=IF(B1=1,B8*.1,IF(B1=2,B8*.2,IF(B1=3,B8*.3,"ERROR, B1 isn't 1, 2, or 3.")))

I try to add that you sent me but i got error message , mybe i make mistake but i just copy-paste your formula in cell B10 ,

#### mikie1881

##### New Member
I will try to explain better this time.
Cel B7 the value manually changes from 1 to 2 or 3
Cell B8 the value in this cell comes from a calculation on B1.
In Cell 9 i want the value of Cell B8 * Cell B7 ( if B7 =1 then *10% if B7=2 then*20% if B7=3 then *30%

I hope I did not tire you.
Thank you again

Replies
39
Views
634
Replies
5
Views
132
Replies
1
Views
261
Replies
3
Views
94
Replies
8
Views
76

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,487
Messages
5,831,987
Members
430,100
Latest member
namhnz

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