What didn't you like about yesterday's answers?

--

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