|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2009, 04:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help
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 
|
|
#2
May 21st, 2009, 05:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
=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
|
|
#3
May 21st, 2009, 05:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
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
|
|
#4
May 21st, 2009, 06:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
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
|
|
#5
May 21st, 2009, 06:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
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
|
|
#6
May 21st, 2009, 06:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#7
May 21st, 2009, 06:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
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
|
|
#8
May 21st, 2009, 07:28 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
