Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Formulas
I am trying to create a logic formula doing the following.
IF B9 = A, and C9 = B, then H9 = C I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are combo boxes receiving their lists from sheet 2. Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Formulas
Is this what you are looking for, entered in H9:
=if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true") Regards, Fred "susanmck" wrote in message ... I am trying to create a logic formula doing the following. IF B9 = A, and C9 = B, then H9 = C I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are combo boxes receiving their lists from sheet 2. Any help would be much appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Formulas
Hello Fred,
It is not quite working it is filling the cell with FALSE. This is how I translated the formula you provided: =IF(AND(Sheet1!B9="Sheet2!A2",Sheet1!C9="Sheet2!B2 "),"Sheet2!D2","0") This is sheet 1: QTY Size Style Description Amount Price There is Combo box with items listed from sheet 2 under Size & Style On sheet 2: Sizes listed in Column A (2-18) Styles listed in Column B (2-9) Amounts (in dollars) listed in Column D (2-67) There are 66 possible combinations. I'm not sure if this kind of equation can even exist without being a mile long, but if it can then great. I appreciate your assistance! "Fred Smith" wrote: Is this what you are looking for, entered in H9: =if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true") Regards, Fred "susanmck" wrote in message ... I am trying to create a logic formula doing the following. IF B9 = A, and C9 = B, then H9 = C I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are combo boxes receiving their lists from sheet 2. Any help would be much appreciated. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Formulas
Why are you putting your data and cell addresses in quotes? That turns them
into text. Try the following: =IF(AND(Sheet1!B9=Sheet2!A2,Sheet1!C9=Sheet2!B2),S heet2!D2,0) Regards, Fred "susanmck" wrote in message ... Hello Fred, It is not quite working it is filling the cell with FALSE. This is how I translated the formula you provided: =IF(AND(Sheet1!B9="Sheet2!A2",Sheet1!C9="Sheet2!B2 "),"Sheet2!D2","0") This is sheet 1: QTY Size Style Description Amount Price There is Combo box with items listed from sheet 2 under Size & Style On sheet 2: Sizes listed in Column A (2-18) Styles listed in Column B (2-9) Amounts (in dollars) listed in Column D (2-67) There are 66 possible combinations. I'm not sure if this kind of equation can even exist without being a mile long, but if it can then great. I appreciate your assistance! "Fred Smith" wrote: Is this what you are looking for, entered in H9: =if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true") Regards, Fred "susanmck" wrote in message ... I am trying to create a logic formula doing the following. IF B9 = A, and C9 = B, then H9 = C I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are combo boxes receiving their lists from sheet 2. Any help would be much appreciated. . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Formulas
I used the formula you first gave me that had quotation marks. i just tried
it without quotes but it still gives me false. The more I look at this the more I think it is not going to work. I have 66 possible combinations. Thank you! "Fred Smith" wrote: Why are you putting your data and cell addresses in quotes? That turns them into text. Try the following: =IF(AND(Sheet1!B9=Sheet2!A2,Sheet1!C9=Sheet2!B2),S heet2!D2,0) Regards, Fred "susanmck" wrote in message ... Hello Fred, It is not quite working it is filling the cell with FALSE. This is how I translated the formula you provided: =IF(AND(Sheet1!B9="Sheet2!A2",Sheet1!C9="Sheet2!B2 "),"Sheet2!D2","0") This is sheet 1: QTY Size Style Description Amount Price There is Combo box with items listed from sheet 2 under Size & Style On sheet 2: Sizes listed in Column A (2-18) Styles listed in Column B (2-9) Amounts (in dollars) listed in Column D (2-67) There are 66 possible combinations. I'm not sure if this kind of equation can even exist without being a mile long, but if it can then great. I appreciate your assistance! "Fred Smith" wrote: Is this what you are looking for, entered in H9: =if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true") Regards, Fred "susanmck" wrote in message ... I am trying to create a logic formula doing the following. IF B9 = A, and C9 = B, then H9 = C I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are combo boxes receiving their lists from sheet 2. Any help would be much appreciated. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Formulas look different | Excel Discussion (Misc queries) | |||
Excel 2007 and IF formulas | Excel Discussion (Misc queries) | |||
Excel 2007 and IF formulas | Excel Discussion (Misc queries) | |||
Excel 2007 formulas | Excel Discussion (Misc queries) | |||
Formulas in excel 2007 | Excel Discussion (Misc queries) |