Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have multiple "If" statements in one formula? | Excel Discussion (Misc queries) | |||
Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |