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

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

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

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

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