Tsqman

2012-04-05, 05:11 PM

Is it possible to combine 2 or more IF(AND statements into one IF(AND(OR statement in Excel 2007?

Following are two examples in which I'm attempting to make it easier to follow my question.

Example One: Written separately it would like this:

=IF(AND(Length<=0.875,Nominal_Size<=0.625),0.031,0.094)

=IF(AND(Length>=1.000,Nominal_Size<=0.625),0.063,0.094)

Length = Looks at a cell with a value (Example 0.500, 1.000, 2.000 etc.).

Nominal_Size = Looks at a cell with a value (Example 0.500, 0.625, 0.750 etc.).

Is there a way to combine these two statements into a single cell?

Example Two: Written separately it would like this:

=IF(AND(Length<=0.875,Nominal_Size<=0.625),0.250,0.313)

=IF(AND(Length =1.000,Nominal_Size<=0.625),0.407,0.438)

=IF(AND(Length =1.125,Nominal_Size<=0.625),0.407,0.438)

=IF(AND(Length>=1.250,Nominal_Size<=0.625),0.594,0.625)

Length = Looks at a cell with a value (Example 0.500, 1.000, 2.000 etc.).

Nominal_Size = Looks at a cell with a value (Example 0.500, 0.625, 0.750 etc.).

Is there a way to combine these four statements into a single cell?

Thank you in advance for your help.

Following are two examples in which I'm attempting to make it easier to follow my question.

Example One: Written separately it would like this:

=IF(AND(Length<=0.875,Nominal_Size<=0.625),0.031,0.094)

=IF(AND(Length>=1.000,Nominal_Size<=0.625),0.063,0.094)

Length = Looks at a cell with a value (Example 0.500, 1.000, 2.000 etc.).

Nominal_Size = Looks at a cell with a value (Example 0.500, 0.625, 0.750 etc.).

Is there a way to combine these two statements into a single cell?

Example Two: Written separately it would like this:

=IF(AND(Length<=0.875,Nominal_Size<=0.625),0.250,0.313)

=IF(AND(Length =1.000,Nominal_Size<=0.625),0.407,0.438)

=IF(AND(Length =1.125,Nominal_Size<=0.625),0.407,0.438)

=IF(AND(Length>=1.250,Nominal_Size<=0.625),0.594,0.625)

Length = Looks at a cell with a value (Example 0.500, 1.000, 2.000 etc.).

Nominal_Size = Looks at a cell with a value (Example 0.500, 0.625, 0.750 etc.).

Is there a way to combine these four statements into a single cell?

Thank you in advance for your help.