Code:

`=IF(F32>0,ROUNDUP(AVERAGE(F7:F25),0),0)`

I need to add the following rules to it but I am not sure how to get it to work:

For every 2 above 4 in cell F32, add 2 to the final average.

Example #1 : F32 = 6, the average (rounded up) of cells F7:F25 = 5, then add 2 so F30 = 7.

Example #2 : F32 = 8, the average (rounded up) of cells F7:F25 = 5, then add 4 so F30 = 9.

I also need the same thing to happen for every 2 less than 4 in cell F32, then subtract 2 from the final average, but minimum value = 1.

I hope that explains things enough. Thanks!