Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested functions
I am trying to set up a formula, such as below but can't get past the first
"if function. Can someone help So far this is what I have =IF(A2="BIRS",E20,0) I have 2 critierias that must be true : A2 must = specific words and E 2 must be greater than zero. If both are true then I need the number that is in cell E 2 to copy to a different workbook in a new cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested functions
=IF(AND(A2="BIRS",E20),E2,0)
The last "0" is what will be if either or both criterias are not true. HTH, Paul -- "Joyce" wrote in message ... I am trying to set up a formula, such as below but can't get past the first "if function. Can someone help So far this is what I have =IF(A2="BIRS",E20,0) I have 2 critierias that must be true : A2 must = specific words and E 2 must be greater than zero. If both are true then I need the number that is in cell E 2 to copy to a different workbook in a new cell |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested functions
Try =IF(AND([Book2]Sheet1!A2="BIRS",[Book2]Sheet1!E20),E2,"")
change Book2 to the actual name of the second workbook and Sheet1 to the actual sheet name best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joyce" wrote in message ... I am trying to set up a formula, such as below but can't get past the first "if function. Can someone help So far this is what I have =IF(A2="BIRS",E20,0) I have 2 critierias that must be true : A2 must = specific words and E 2 must be greater than zero. If both are true then I need the number that is in cell E 2 to copy to a different workbook in a new cell |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested functions
How do I get the contents of the last cell to move to a new workbook cell.
So, If all criteria's are true, then I want a number 1 to move to a new workbook cell "PCLIVE" wrote: =IF(AND(A2="BIRS",E20),E2,0) The last "0" is what will be if either or both criterias are not true. HTH, Paul -- "Joyce" wrote in message ... I am trying to set up a formula, such as below but can't get past the first "if function. Can someone help So far this is what I have =IF(A2="BIRS",E20,0) I have 2 critierias that must be true : A2 must = specific words and E 2 must be greater than zero. If both are true then I need the number that is in cell E 2 to copy to a different workbook in a new cell |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested functions
Sorry. I missed the part about a different workbook. See Bernard Liengme's
response. -- "Joyce" wrote in message ... How do I get the contents of the last cell to move to a new workbook cell. So, If all criteria's are true, then I want a number 1 to move to a new workbook cell "PCLIVE" wrote: =IF(AND(A2="BIRS",E20),E2,0) The last "0" is what will be if either or both criterias are not true. HTH, Paul -- "Joyce" wrote in message ... I am trying to set up a formula, such as below but can't get past the first "if function. Can someone help So far this is what I have =IF(A2="BIRS",E20,0) I have 2 critierias that must be true : A2 must = specific words and E 2 must be greater than zero. If both are true then I need the number that is in cell E 2 to copy to a different workbook in a new cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF functions | Excel Discussion (Misc queries) | |||
Nested Functions | Excel Discussion (Misc queries) | |||
too many nested IF functions | Excel Worksheet Functions | |||
NESTED IF FUNCTIONS | Excel Worksheet Functions | |||
Nested Functions | Excel Worksheet Functions |