 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006How 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? A1: =IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1="D&F",C1="RM"),"Ronald","") Regards Trevor >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? 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/community/en-us/default.mspx?&guid=&sloc=en-us&d g=microsoft.public.excel.worksheet.functions&p=1&tid=4ce3fa03-827f-4ff4-8796-8a0 d83b770db&mid=a3be3b91-af0a-419c-ae0f-f6f7d2f3b9b3 Thanks again for your assistance. > A1: > =IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1="D&F",C1="RM"),"Ronald","") [quoted text clipped - 9 lines] > > > > How do I write the IF and AND function for the situation mentioned above? I have replied to you in the original thread Regards Trevor > Dear Trevor, > [quoted text clipped - 26 lines] >> > How do I write the IF and AND function for the situation mentioned >> > above? 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  SignatureRegards Roger Govier > Dear Trevor, > [quoted text clipped - 27 lines] >> > How do I write the IF and AND function for the situation mentioned >> > above? 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! > Hi > [quoted text clipped - 48 lines] > >> > How do I write the IF and AND function for the situation mentioned > >> > above? Hi Thank you for your response. You are more than welcome. I'm sure I speak for Trevor as well. SignatureRegards Roger Govier > Dear Roger & Trevor, > [quoted text clipped - 63 lines] >> >> > mentioned >> >> > above? 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 > Dear Roger & Trevor, > [quoted text clipped - 54 lines] >> >> > How do I write the IF and AND function for the situation mentioned >> >> > above? 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? > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.