#### Matt_Thompson

##### Board Regular

- Joined
- Apr 5, 2004

- Messages
- 101

I hope someone can help or at least put me in the right direction.

I have 3 offset formula's which I need to combine. This in itself shouldn't be a problem (I don't think!) but to make this a bit more complex, I have been told that the result of the offsets need to be capped at 20%+/-.

The 3 offsets are:

=SUM(I10:OFFSET(I10,0,$BQ$1-2))/SUM(I2:OFFSET(I2,0,$BQ$1-2))

**divided by**

=SUM(U10:OFFSET(U10,0,$BQ$1-2))/SUM(U2:OFFSET(U2,0,$BQ$1-2))

**multiply**

=OFFSET(I10,0,$BQ$1-1)

In the offsets

**I10**is this years monthly figures and

**$BQ$1**is the offset that is showing the current period.

**I2**is the number of calendar days for that month.

**U10**is last years monthly figures and the last offset is showing what the current Period figure is.

If I put all 3 formulae together, how would I then cap the outcome at between +20% and -20%?

Thanks in advance,

Matt