#### 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
3
Views
46
Replies
1
Views
38
Replies
4
Views
55
Replies
5
Views
68
Replies
5
Views
88