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

=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

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

c1 has a seperate function and is corrupting d1 can i hide c1 function so d1
doesn't pick it up
--
Chris


"Bob Phillips" wrote:

=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

C1 has its own function that is corrupting E1 can i tell the below function
to ignore C1 function
--
Chris


"Bob Phillips" wrote:

=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

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

Hi Chris,
Sorry but I don't know what to want to achieve if you don't want C1 to be
part of the formula just delete it , but C1 is just a multiplier

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

"Chris" wrote:

C1 has its own function that is corrupting E1 can i tell the below function
to ignore C1 function
--
Chris


"Bob Phillips" wrote:

=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

Im sorry C1 has a function =I11/.95 so when I put the function for E1 the
total for the multiplier is off .21 If i erace C1 function it calculates
correctly
--
Chris


"Eduardo" wrote:

Hi Chris,
Sorry but I don't know what to want to achieve if you don't want C1 to be
part of the formula just delete it , but C1 is just a multiplier

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

"Chris" wrote:

C1 has its own function that is corrupting E1 can i tell the below function
to ignore C1 function
--
Chris


"Bob Phillips" wrote:

=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