Help
Hi Eduardo,
The formula worked exept that C1 has a function and the function you gave me
is getting corrupted by C1. Can I have E1 function ignore C1
--
Chris
"Eduardo" wrote:
Hi
=IF(D1="mlf",A1*B1*C1/1000,IF(D1="RL",B1*C1,""))
I include in the formula to leave blank if none of the two results are in D1
if this helped please click yes, thanks
"Chris" wrote:
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
|