1 from column A, 1 from column B - you get egg roll!

[golfnutte]

OK, I'll try this again, here's what I want to accomplish:

Cell A40 is the sum of a column. Cell B40 is the sum of a column. I want the sum of cell A40 to reduce by 30% "if" cell B40 is equals 12 or more.

So I want to total the A column in cell A40 and multiply it by .70 if the sum in A40 is greater than 12.

Anyone know how to accomplish this?

A big THANK YOU!

[FrankBoston]

A40: =sum(A3:A39) * IF(B40>12, 0.70, 1)

[golfnutte]

Hi and thanks for the reply, my column totals just fine now, but it did not perform the multiplying part and consequently reduce my sum by 30%...????

[MrShorty]

I don't see anything wrong with Frank's formula. What's in B40?