Excel function
Bob, thanks for the effort and turning on the light.
Harlan, thank you, sir, for the eclipse! You were right on!!!
"Harlan Grove" wrote:
"Bob Phillips" wrote...
=IF(SUM(E2:E2)=A2,0,IF(AND(SUM(C2:E2)<A2,SUM(C2:E 2)B2*3),
B2*3,SUM(C2:E2)))
....
I suspect your first SUM term is a typo and you meant
=IF(SUM(C2:E2)=A2,0,IF(AND(SUM(C2:E2)<A2,SUM(C2:E2 )B2*3),
B2*3,SUM(C2:E2)))
However, I don't think that's what the OP requested. My take on it is
=IF(SUM($C2:E$2)=$A2,0,IF(SUM($C2:$E3)3*$B2,3*$B 2,$A2-SUM($C2:$E2)))
with the column-absolute references due to the OP's 'sum of column c
through one cell before Col f', which leads me to suspect the formula
would go into F2 then be filled right. I've seen residual amounts
spread in similar manner before.
|