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.

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.

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.

.

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.

.

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.

.


.