If formula

M

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

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