AND and IF Functions
 

Hi! Is there anyway to get the AND and IF functions to work correctly
in one formula. I know that you can't nest functions that don't give
you the same type of answer. Here's what I'm looking to do...

I have three columns (A and B and C). Columns A and B have either Yes
or No entered into them. Column C has a number entered in to it. What
I need to do is have Column C's number entered into a new column (column
D) if both Columns A and B are Yes's. Here's an example:

A B C D
Yes No $500 -
No Yes $200 -
Yes Yes $300 $300

The only way I've been able to figure out is by doing an AND function
in a new column and then doing the IF function into it's own column.
Basically, I'm just trying to combine the two. Can anyone help?
Thanks!


--
fosterp
------------------------------------------------------------------------
fosterp's Profile: http://www.excelforum.com/member.php...o&userid=16316
View this thread: http://www.excelforum.com/showthread...hreadid=277087

With any function call...

=(A1="Yes")*(B1="Yes")*C1

Using IF...

=IF(AND(A1="Yes",B1="Yes"),C1,0)

fosterp Wrote:
Hi! Is there anyway to get the AND and IF functions to work correctly
in one formula. I know that you can't nest functions that don't give
you the same type of answer. Here's what I'm looking to do...

I have three columns (A and B and C). Columns A and B have either Yes
or No entered into them. Column C has a number entered in to it. What
I need to do is have Column C's number entered into a new column (column
D) if both Columns A and B are Yes's. Here's an example:

A B C D
Yes No $500 -
No Yes $200 -
Yes Yes $300 $300

The only way I've been able to figure out is by doing an AND function
in a new column and then doing the IF function into it's own column.
Basically, I'm just trying to combine the two. Can anyone help?
Thanks!


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=277087

Hi
in D1 enter
=IF(AND(A1="Yes",B1="Yes"),C1,0)

or as alternative
=(COUNTIF(A1:B1,"Yes")=2)*C1

--
Regards
Frank Kabel
Frankfurt, Germany

"fosterp" schrieb im Newsbeitrag
...

Hi! Is there anyway to get the AND and IF functions to work
correctly
in one formula. I know that you can't nest functions that don't give
you the same type of answer. Here's what I'm looking to do...

I have three columns (A and B and C). Columns A and B have either
Yes
or No entered into them. Column C has a number entered in to it.
What
I need to do is have Column C's number entered into a new column
(column
D) if both Columns A and B are Yes's. Here's an example:

A B C D
Yes No $500 -
No Yes $200 -
Yes Yes $300 $300

The only way I've been able to figure out is by doing an AND function
in a new column and then doing the IF function into it's own column.
Basically, I'm just trying to combine the two. Can anyone help?
Thanks!


--
fosterp
---------------------------------------------------------------------
---
fosterp's Profile:
http://www.excelforum.com/member.php...o&userid=16316
View this thread:
http://www.excelforum.com/showthread...hreadid=277087