Formula working but need simplified mathematics

**makinmomb** · 04-21-2014, 10:24 AM

I am already using this formula , serves
me purpose too , but I think its possible
to modify it look simpler

Someone , I think you just have to place
the brackets correctly to do the divisions
over horizontal running total

**martindwilson** · 04-21-2014, 10:39 AM

if you are talking about the bit in green then it could be just
=iferror((SUM($B2:B2)/B$22-$J2)/$J2,"")

**makinmomb** · 04-21-2014, 11:06 AM

Yes this is it , I picked +(SUM($B2:B2)/B$22-$J2)/$J2
MARTINDWILSON thanks for the most simple version
that I can comprehend and re do , I was sure the
answer existed into so I was sure to ask