How do I write the IF function to reflect the result in one cell?
 

I want to yield in the 1st cell "William" when I choose "Grocery" in another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned above?

How do I write the IF function to reflect the result in one cell?
 

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned above?

How do I write the IF function to reflect the result in one cell?
 

Dear AMBO,

With "Grocery" & "MT" being in 2 separate columns and the result being
William, would "Ronald" & "D&F" appear in those same 2 columns or would they
be in different columns (in other words would there be 4 separate columns of
criteria)? Also, do you want William and Ronald to appear in 2 separate
cells depending on the criteria, or do you simply want the same cell to
either display William or Ronald depending on those criteria?

"AMBO" wrote:

I want to yield in the 1st cell "William" when I choose "Grocery" in another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned above?

How do I write the IF function to reflect the result in one ce
 

Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including month)."
You helped answer part of my question but I had posted another question to
you in the same post. If you could please look at the thread and post your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned above?

How do I write the IF function to reflect the result in one ce
 

I have replied to you in the original thread

Regards

Trevor


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another question to
you in the same post. If you could please look at the thread and post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F"
in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned
above?

How do I write the IF function to reflect the result in one ce
 

Hi

In case you cannot see it for some reason, Trevor answered you question
as

Something like:

=SUMPRODUCT(($J$49:$J$73=DATE(2006,7,1))*($J$49: $J$73<=DATE(2007,6,30))*(MONTH($J$49:$J$73)=7)*($ K$49:$K$73=$AC14))

Regards

Trevor

With regard to extending to additional rows of data as they are added,
you would need to use Dynamic named ranges as the range for your data
sets.

Once again, you will find excellent instruction on this at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic


--
Regards

Roger Govier


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another
question to
you in the same post. If you could please look at the thread and post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose
"D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned
above?

How do I write the IF function to reflect the result in one ce
 

Dear Roger & Trevor,

I replied in the original thread also but I'll post here just in case
you don't look at the original thread. Thanks to both of you for all your
help!

"Roger Govier" wrote:

Hi

In case you cannot see it for some reason, Trevor answered you question
as

Something like:

=SUMPRODUCT(($J$49:$J$73=DATE(2006,7,1))*($J$49: $J$73<=DATE(2007,6,30))*(MONTH($J$49:$J$73)=7)*($ K$49:$K$73=$AC14))

Regards

Trevor

With regard to extending to additional rows of data as they are added,
you would need to use Dynamic named ranges as the range for your data
sets.

Once again, you will find excellent instruction on this at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic


--
Regards

Roger Govier


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another
question to
you in the same post. If you could please look at the thread and post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose
"D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned
above?

How do I write the IF function to reflect the result in one ce
 

Hi

Thank you for your response. You are more than welcome.
I'm sure I speak for Trevor as well.

--
Regards

Roger Govier


"RS" wrote in message
...
Dear Roger & Trevor,

I replied in the original thread also but I'll post here just in
case
you don't look at the original thread. Thanks to both of you for all
your
help!

"Roger Govier" wrote:

Hi

In case you cannot see it for some reason, Trevor answered you
question
as

Something like:

=SUMPRODUCT(($J$49:$J$73=DATE(2006,7,1))*($J$49: $J$73<=DATE(2007,6,30))*(MONTH($J$49:$J$73)=7)*($ K$49:$K$73=$AC14))

Regards

Trevor

With regard to extending to additional rows of data as they are
added,
you would need to use Dynamic named ranges as the range for your data
sets.

Once again, you will find excellent instruction on this at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic


--
Regards

Roger Govier


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get
in
touch with you. I had posted a question in the Excel forums
yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another
question to
you in the same post. If you could please look at the thread and
post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery"
in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose
"D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation
mentioned
above?

How do I write the IF function to reflect the result in one ce
 

Roger does indeed speak for me ... you are very welcome. Thanks for letting
us know that we were able to help.

I generally use "Show Replies to my Messages" to track posts that I have
replied to so I would see your response ... but thanks for the belt and
braces.

Regards

Trevor


"RS" wrote in message
...
Dear Roger & Trevor,

I replied in the original thread also but I'll post here just in case
you don't look at the original thread. Thanks to both of you for all your
help!

"Roger Govier" wrote:

Hi

In case you cannot see it for some reason, Trevor answered you question
as

Something like:

=SUMPRODUCT(($J$49:$J$73=DATE(2006,7,1))*($J$49: $J$73<=DATE(2007,6,30))*(MONTH($J$49:$J$73)=7)*($ K$49:$K$73=$AC14))

Regards

Trevor

With regard to extending to additional rows of data as they are added,
you would need to use Dynamic named ranges as the range for your data
sets.

Once again, you will find excellent instruction on this at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic


--
Regards

Roger Govier


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another
question to
you in the same post. If you could please look at the thread and post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose
"D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned
above?