Make my figures divisable by 3
 

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

Make my figures divisable by 3
 

=MROUND(A1, 3)

Vaya con Dios,
Chuck, CABGx3




"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

Make my figures divisable by 3
 

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

"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

Make my figures divisable by 3
 

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


Replace @mailinator.com with @tiscali.co.uk


"Shazza" wrote in message
...
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

Make my figures divisable by 3
 

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

Make my figures divisable by 3
 

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



"MrAcquire" wrote:

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