SumProduct Help
Two problems in my second formula:
Of course the 8s in the cell references should have been 4s. I was testing
with a copy on another row.
More significantly I slipped a decimal point!
=SUMPRODUCT(ROUNDUP(Q4:AY4*(0.01+1.01*SIGN(Q4:AY4) ),0))
--
David Biddulph
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You could try =SUMPRODUCT(ROUNDUP(Q4:AY4*(IF(Q4:AY4<0,-1,1.02)),0)) as an
array formula
Or =SUMPRODUCT(ROUNDUP(Q8:AY8*(0.1+1.01*SIGN(Q8:AY8)) ,0)), which doesn't
need to be an array formula.
--
David Biddulph
"Sandy" wrote in message
...
Hello
I need to modify my sumproduct formula:
SUMPRODUCT(ROUNDUP(Q4:AY4*1.02,0))
Such that if Q4:AY4 0 ROUNDUP(Q4:AY4*1.02,0) and if < 0 abs(Q4:AY4)
Thanks
|