HELP! Multiple if statements on the same line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chemboy - 23 Jan 2006 19:20 GMT

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

Reply to this Message

Chip Pearson - 23 Jan 2006 19:28 GMT

Try

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

Signature

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

> How do I get excel to give an answer when two conditions must
> be met?
[quoted text clipped - 13 lines]
> Anyone have any suggesations?
> Thank you in advance for any help

Reply to this Message

Chemboy - 30 Jan 2006 16:41 GMT

It worked wonderfully!

Thank you so much.

> Try
>
[quoted text clipped - 17 lines]
> > Anyone have any suggesations?
> > Thank you in advance for any help

Reply to this Message

Anne Troy - 23 Jan 2006 19:28 GMT

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

> 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.
[quoted text clipped - 10 lines]
> Anyone have any suggesations?
> Thank you in advance for any help

Reply to this Message