=ROUND((B3+($C$2*B3))/3,0)*3

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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