HELP! Multiple if statements on the same line

[Chemboy]

How do I get excel to give an answer when two conditions must be met?
Basically, if L42>L43 and L43>0. 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, x>y>0 is valad, is it not? Here is what has been tried so far:
if L42>L43 AND L43>0
if L42>L43 & L43>0
if L42>L43 + L43>0
if L43<L42 and 0<L43

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

[Anne Troy]

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

"Chemboy" <[email protected]> wrote in message
news:[email protected]...
> How do I get excel to give an answer when two conditions must be met?
> Basically, if L42>L43 and L43>0. 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, x>y>0 is valad, is it not? Here is what has been tried so
> far:
> if L42>L43 AND L43>0
> if L42>L43 & L43>0
> if L42>L43 + L43>0
> if L43<L42 and 0<L43
>
> Anyone have any suggesations?
> Thank you in advance for any help

[Chip Pearson]

Try

=IF(AND(L42>L43,L43>0),true,false)

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


"Chemboy" <[email protected]> wrote in message
news:[email protected]...
> How do I get excel to give an answer when two conditions must
> be met?
> Basically, if L42>L43 and L43>0. 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, x>y>0 is valad, is it not? Here is what has
> been tried so far:
> if L42>L43 AND L43>0
> if L42>L43 & L43>0
> if L42>L43 + L43>0
> if L43<L42 and 0<L43
>
> Anyone have any suggesations?
> Thank you in advance for any help

[Chemboy]

It worked wonderfully!

Thank you so much.



"Chip Pearson" wrote:

> Try
>
> =IF(AND(L42>L43,L43>0),true,false)
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Chemboy" <[email protected]> wrote in message
> news:[email protected]...
> > How do I get excel to give an answer when two conditions must
> > be met?
> > Basically, if L42>L43 and L43>0. 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, x>y>0 is valad, is it not? Here is what has
> > been tried so far:
> > if L42>L43 AND L43>0
> > if L42>L43 & L43>0
> > if L42>L43 + L43>0
> > if L43<L42 and 0<L43
> >
> > Anyone have any suggesations?
> > Thank you in advance for any help
>
>
>