View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shazza Shazza is offline
external usenet poster
 
Posts: 31
Default 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