Please i need your help to create formula

[mikie1881]

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%.

Thank you in advance

Michell

 

[Tarver]

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.

 

[mikie1881]

=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]

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]

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 .

 

[Tarver]

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

 

[mikie1881]

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]

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]

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]

If you normally use a comma then that's not the problem.
These work for me

+Fluff New.xlsm
	A	B	C
5
6			1.6
7		2	1.6
8		8	1.6
Data

Cell Formulas
Range	Formula
C6	C6	=(B7*B8*0.1)
C7	C7	=B7*B8*0.1
C8	C8	=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]

If you normally use a comma then that's not the problem.
These work for me

+Fluff New.xlsm
	A	B	C
5
6			1.6
7		2	1.6
8		8	1.6
Data

Cell Formulas
Range	Formula
C6	C6	=(B7*B8*0.1)
C7	C7	=B7*B8*0.1
C8	C8	=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.