Dear M.=B7/10*B8
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")))
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?
If you normally use a comma then that's not the problem.
These work for me
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")))