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.