F
fosterp
Hi! Is there anyway to get the AND and IF functions to work correctl
in one formula. I know that you can't nest functions that don't giv
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 Ye
or No entered into them. Column C has a number entered in to it. Wha
I need to do is have Column C's number entered into a new column (colum
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 functio
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
in one formula. I know that you can't nest functions that don't giv
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 Ye
or No entered into them. Column C has a number entered in to it. Wha
I need to do is have Column C's number entered into a new column (colum
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 functio
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