If formula

[Mike]

Please help with a formula using "IF". If one cell
says "LP108" then another cell should be mulitiplied
by .06 --- If not it should be multiplied by .04. Thanks
for the help.

 

[Lady Layla]

If B1 is where the LP108 may be and C1 is the cell you want multiplied,
enter this in B2 =IF(B1="LP108",C1*.06,C18*.04)


: Please help with a formula using "IF". If one cell
: says "LP108" then another cell should be mulitiplied
: by .06 --- If not it should be multiplied by .04. Thanks
: for the help.