Combining formulas

**skip2mylew** · 06-04-2013, 09:56 PM

I need to combine this into 1 formula.

If BQ4-$CY$1<=-1 and BG4 = 10 then the cell should equal 30%

or

If BQ4-$CY$1<=-1 and BG4 = 2 then the cell should equal 75%

or

If BQ4-$CY$1<=-1 and BF4 = "Salsa" then the cell should equal 50%

**alansidman** · 06-04-2013, 10:14 PM

If(and((BQ4-$CY$1)<=-1,BG=10),.3,if(and((BQ4-$CY$1)<=-1,BG=2,.75,if(and((BQ4-$CY$1)<=-1,BF4="Salsa"),.5,Value if none of the criteria apply)))

**skip2mylew** · 06-04-2013, 10:19 PM

That formula doesn't work. I tried that too but it says there is a problem with the formula.

**alansidman** · 06-04-2013, 10:20 PM

What is the error message. What results do you get. Need more info to help you.

**skip2mylew** · 06-04-2013, 10:35 PM

The error says, "We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems."

It won't let me enter the formula. I have to delete the formula or change it.

**skip2mylew** · 06-04-2013, 10:41 PM

I got it. I had to include some other stuff but the formula I have is:

IF(OR(BD4="Cooler",BD4="CoolerOut",BD4="CoolerOverstock"),IF(AND(BQ4<>"",BQ4-$CY$1<=-1,BG4=10,BF4="Salsa"),0.5,IF(AND(BQ4<>"",BQ4-$CY$1<=-1,BG4=14),0.3,IF(AND(BQ4<>"",BQ4-$CY$1<=-1,BG4=2),0.75,IF(AND(BQ4<>"",BQ4-$CY$1<=-1,BG4=10),0.3,"")))))

**alansidman** · 06-04-2013, 10:42 PM

Found the error

try this: If(and((BQ4-$CY$1)<=-1,BG4=10),.3,if(and((BQ4-$CY$1)<=-1,BG4=2,.75,if(and((BQ4-$CY$1)<=-1,BF4="Salsa"),.5,Value if none of the criteria apply)))

Missed the cell in BG4; had just BG