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

#### Tarver

##### Board Regular
So cell B9 should be =IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"ERROR: Cell B7 is not a 1, 2, or 3.")))

Or, you could just make the formula in cell B9 to be =B7/10*B8 That would let you enter any value in B7, and get 10% of the entry.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### mikie1881

##### New Member
=B7/10*B8
Dear M.
when i copy-paste the first formula you sent me i still get error message , maybe because i have 2013 version ?

#### ShuStar

##### Board Regular
So it's pretty much what Tarver said, but change b1 to b7 as below:

If(b7=1, b8*0.1, if b7=2, b8*0.2, if b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3")))

#### mikie1881

##### New Member
If(b7=1, b8*0.1, if b7=2, b8*0.2, if b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3")))

Hi M.
No matter what i do i get this error message .

#### Attachments

• Untitled-1.psd.jpg
63.4 KB · Views: 6

#### Tarver

##### Board Regular

Are you starting the formula with an equal sign (=)?

#### mikie1881

##### New Member
yes , i try to use google exls docs and when i change to >> =If(b7=1, b8*0.1, if (b7=2, b8*0.2, if (b7=3, b8*0.3, "Error - check if B7 is 1,2 or 3"))) then on google works but still not works on excell !!

#### Fluff

##### MrExcel MVP, Moderator

Did the formula from post#6 work for you?
Also what is the separator you normally use in a formula, is it a comma or semi-colon?

#### mikie1881

##### New Member
Did the formula from post#6 work for you?
Also what is the separator you normally use in a formula, is it a comma or semi-colon?

Only when open parentheses before B7 then works on google xls docs, on microsoft excel no works, about separator i use comma , is this the problem ?

#### Fluff

##### MrExcel MVP, Moderator
If you normally use a comma then that's not the problem.
These work for me
+Fluff New.xlsm
ABC
5
61.6
721.6
881.6
Data
Cell Formulas
RangeFormula
C6C6=(B7*B8*0.1)
C7C7=B7*B8*0.1
C8C8=IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"Error - check if B7 is 1,2 or 3")))

• mikie1881

#### mikie1881

##### New Member
If you normally use a comma then that's not the problem.
These work for me
+Fluff New.xlsm
ABC
5
61.6
721.6
881.6
Data
Cell Formulas
RangeFormula
C6C6=(B7*B8*0.1)
C7C7=B7*B8*0.1
C8C8=IF(B7=1,B8*0.1,IF(B7=2,B8*0.2,IF(B7=3,B8*0.3,"Error - check if B7 is 1,2 or 3")))

Inspired from your question about comma or semicolon i change on option to system separator and WORKS perfect ! Thank you again.

Replies
3
Views
46
Replies
1
Views
38
Replies
4
Views
54
Replies
5
Views
68
Replies
5
Views
88