Rounding numbers so that they are divisable by 3
1 B C
2 Original figure Annual Increase
divisible by 3
3 2.25%
£ 15,441.00 £15,788.4225
I want C3 to read £15789.00 as it is the nearest number to £15788.4225 that
is divisible by 3
The formula i used in C3 is =B3+($C$2*B3)
How can i amend this formula to ensure that my figure is divisable by 3
--
Thank you for reading my post. Hopefully you can answer my querie
|