software

How do I get excel to give an answer when two conditions must be met?
Basically, if L42gt;L43 and L43gt;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, xgt;ygt;0 is valad, is it not? Here is what has been tried so far:
if L42gt;L43 AND L43gt;0
if L42gt;L43 amp; L43gt;0
if L42gt;L43 L43gt;0
if L43lt;L42 and 0lt;L43

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

Try

=IF(AND(L42gt;L43,L43gt;0),true,false)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Chemboyquot; gt; wrote in message
...
gt; How do I get excel to give an answer when two conditions must
gt; be met?
gt; Basically, if L42gt;L43 and L43gt;0. If true, it goes on to a
gt; calculation. If
gt; false, the result is supposed to be 0. I can get condition
gt; one to work,
gt; but not both. Is it even possible to have two on the same
gt; line?
gt; Mathmatically, xgt;ygt;0 is valad, is it not? Here is what has
gt; been tried so far:
gt; if L42gt;L43 AND L43gt;0
gt; if L42gt;L43 amp; L43gt;0
gt; if L42gt;L43 L43gt;0
gt; if L43lt;L42 and 0lt;L43
gt;
gt; Anyone have any suggesations?
gt; Thank you in advance for any help
=IF(and(L42gt;L43,L43gt;0),L43*1,0)
where L43*1 should be YOUR calculation...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Chemboyquot; gt; wrote in message
...
gt; How do I get excel to give an answer when two conditions must be met?
gt; Basically, if L42gt;L43 and L43gt;0. If true, it goes on to a calculation.
gt; If
gt; false, the result is supposed to be 0. I can get condition one to work,
gt; but not both. Is it even possible to have two on the same line?
gt; Mathmatically, xgt;ygt;0 is valad, is it not? Here is what has been tried so
gt; far:
gt; if L42gt;L43 AND L43gt;0
gt; if L42gt;L43 amp; L43gt;0
gt; if L42gt;L43 L43gt;0
gt; if L43lt;L42 and 0lt;L43
gt;
gt; Anyone have any suggesations?
gt; Thank you in advance for any help
It worked wonderfully!

Thank you so much.
quot;Chip Pearsonquot; wrote:

gt; Try
gt;
gt; =IF(AND(L42gt;L43,L43gt;0),true,false)
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Chemboyquot; gt; wrote in message
gt; ...
gt; gt; How do I get excel to give an answer when two conditions must
gt; gt; be met?
gt; gt; Basically, if L42gt;L43 and L43gt;0. If true, it goes on to a
gt; gt; calculation. If
gt; gt; false, the result is supposed to be 0. I can get condition
gt; gt; one to work,
gt; gt; but not both. Is it even possible to have two on the same
gt; gt; line?
gt; gt; Mathmatically, xgt;ygt;0 is valad, is it not? Here is what has
gt; gt; been tried so far:
gt; gt; if L42gt;L43 AND L43gt;0
gt; gt; if L42gt;L43 amp; L43gt;0
gt; gt; if L42gt;L43 L43gt;0
gt; gt; if L43lt;L42 and 0lt;L43
gt; gt;
gt; gt; Anyone have any suggesations?
gt; gt; Thank you in advance for any help
gt;
gt;
gt;