| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| How to .. | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
