Make my figures divisable by 3

[Shazza]

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

 

[CLR]

=MROUND(A1, 3)

Vaya con Dios,
Chuck, CABGx3

 

[FSt1]

hi
once you have the final figure, you can use
=roundup(15788.4225,0) = 15789
the zero = number of decimal places.
you can also use =rounddown if the numbers were such that you needed to
round down.
you might be able to work it into your fomulas but it looks like the process
is broken up.

regards
FSt1

 

[Sandy Mann]

15788.4225 is 15441 * 102.25% not 102.5%

With the original figure in C5 and 2.5% in D5 and knowing employers I assume
that you mean the nearest multiple of 3 DOWN then try

=FLOOR(G17*(1+$D$4),3)

If you do mean the nearest multiple of 3 then use:

=ROUND(C5*(1+$D$4)/3,0)*3

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[MrAcquire]

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))

 

[MrAcquire]

Sandy makes a good point about another option, so I'm revising my answer.

If you want to round to the nearest number divisible by 3,
=MROUND(C5*(1+$D$4,3))

If you want to round down to a number divisible by 3,
=FLOOR(C5*(1+$D$4),3)

If you want to round up to a number divisible by 3,
=CEILING(C5*(1+$D$4),3)
is a better formula than
=IF(MOD(C5*(1+$D$4),3)<1.5,3+MROUND(C5*(1+$D$4),3),MROUND(C5*(1+$D$4),3)).