This solution assumes that your desired percent increase is in $D$4, your old
salaries are in C5..Cn, and you always want the number divisible by 3.

If you want to round to the nearest number divisible by 3, enter the
following in D5 and copy down to Dn:

=MROUND(C5*(1+$D$4,3))

If you always want to round UP to the nearest number divisible by 3, enter
the following in D5 and copy down to Dn:

=IF(MOD(C5*(1+$D$4),3)<1.5,3+MROUND(C5*(1+$D$4),3) ,MROUND(C5*(1+$D$4),3))


"Shazza" wrote:

I am trying to take a wages annual figure and increase it by 2.5% but then
make the end figure be divisible by 3.

e.g. £15441 (the formula I used was C5 + ($D$4*C5) to pick up the initial
figure and find out 2.5 % then add it to the first figure.

Now I need to make that final figure £15788.4225 change to read £15789
(because that figure can then divided by 3)

Is this possible and if so how
--
Thank you for reading my post. Hopefully you can answer my querie