HELP! Multiple if statements on the same line
 

How do I get excel to give an answer when two conditions must be met?
Basically, if L42L43 and L430. If true, it goes on to a calculation. If
false, the result is supposed to be 0. I can get condition one to work,
but not both. Is it even possible to have two on the same line?
Mathmatically, xy0 is valad, is it not? Here is what has been tried so far:
if L42L43 AND L430
if L42L43 & L430
if L42L43 + L430
if L43<L42 and 0<L43

Anyone have any suggesations?
Thank you in advance for any help

HELP! Multiple if statements on the same line
 

Try

=IF(AND(L42L43,L430),true,false)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chemboy" wrote in message
...
How do I get excel to give an answer when two conditions must
be met?
Basically, if L42L43 and L430. If true, it goes on to a
calculation. If
false, the result is supposed to be 0. I can get condition
one to work,
but not both. Is it even possible to have two on the same
line?
Mathmatically, xy0 is valad, is it not? Here is what has
been tried so far:
if L42L43 AND L430
if L42L43 & L430
if L42L43 + L430
if L43<L42 and 0<L43

Anyone have any suggesations?
Thank you in advance for any help

HELP! Multiple if statements on the same line
 

=IF(and(L42L43,L430),L43*1,0)
where L43*1 should be YOUR calculation...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Chemboy" wrote in message
...
How do I get excel to give an answer when two conditions must be met?
Basically, if L42L43 and L430. If true, it goes on to a calculation.
If
false, the result is supposed to be 0. I can get condition one to work,
but not both. Is it even possible to have two on the same line?
Mathmatically, xy0 is valad, is it not? Here is what has been tried so
far:
if L42L43 AND L430
if L42L43 & L430
if L42L43 + L430
if L43<L42 and 0<L43

Anyone have any suggesations?
Thank you in advance for any help

HELP! Multiple if statements on the same line
 

It worked wonderfully!

Thank you so much.



"Chip Pearson" wrote:

Try

=IF(AND(L42L43,L430),true,false)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chemboy" wrote in message
...
How do I get excel to give an answer when two conditions must
be met?
Basically, if L42L43 and L430. If true, it goes on to a
calculation. If
false, the result is supposed to be 0. I can get condition
one to work,
but not both. Is it even possible to have two on the same
line?
Mathmatically, xy0 is valad, is it not? Here is what has
been tried so far:
if L42L43 AND L430
if L42L43 & L430
if L42L43 + L430
if L43<L42 and 0<L43

Anyone have any suggesations?
Thank you in advance for any help