Help

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
 
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)
 
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)
 
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
 
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
 
C

Chris

c1 has a seperate function and is corrupting d1 can i hide c1 function so d1
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
 
C

Chris

C1 has its own function that is corrupting E1 can i tell the below 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
 
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
 
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
 
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,""))
 
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,""))
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
split range address into individual cell addresses 4
Baffeling IF statement 7
Combining several cells into single equasion? 1
COUNTING THE SAME VALUES IN A SHEET 3
Adding Cells, Get Error. 2
compare three cells 1
wrong result if function values over 256 4

Top