=IF(D1="mlf",A1*B1*C1/1000,IF(D1="RL",B1*C1,""))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Chris" wrote in message
...
i am trying to get A1*B1*C1/1000 if D1 has "mlf" entered and totalled in
E1
also i want if "RL" entered in D1 to only B1*C1 in E1
--
Chris