C
Chris
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
also i want if "RL" entered in D1 to only B1*C1 in E1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=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)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
B
Bob Phillips
=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)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
E
Eduardo
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
=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
E
Eduardo
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
=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
C
Chris
c1 has a seperate function and is corrupting d1 can i hide c1 function so d1
doesn't pick it up
doesn't pick it up
C
Chris
c1 has a seperate function and is corrupting d1 can i hide c1 function so d1
doesn't pick it up
doesn't pick it up
C
Chris
C1 has its own function that is corrupting E1 can i tell the below function
to ignore C1 function
to ignore C1 function
C
Chris
C1 has its own function that is corrupting E1 can i tell the below function
to ignore C1 function
to ignore C1 function
C
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
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
C
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
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
E
Eduardo
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,""))
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,""))
E
Eduardo
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,""))
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,""))
C
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
total for the multiplier is off .21 If i erace C1 function it calculates
correctly
C
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
total for the multiplier is off .21 If i erace C1 function it calculates
correctly