That's it! Brilliant!

however there seems to be a problem with the original part now. where i
wanted each 5th cell to be read, if the value of that cell was higher than
cell C4 then C4's value would take precedent.

thanks for your help!

steve

"Domenic" wrote in message
...
In article ,
"r.p.mcmurphy" wrote:

Excel is not accepting it for some reason. any idea where the fault may
be?

If you're copying and pasting the formula into your worksheet, make sure
that a line break hasn't been added.

im a bit confused about the bit you added in order to add the value of
BQ4...this bit..

+IF((BQ4<"")*(BQ4C4),C4,BQ4))

why does it refer to C4?

I assumed, incorrectly it appears, that BQ4 would following the same
logic as cells in G4:BJ4. Maybe this what you mean...

=(SUM(IF((G4:BJ4<"")*(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0),IF(G4:BJ4C4,C
4,G4:BJ4)))+BQ4)*0.09615

Is it?