Help with formula for rounding up/down & divisible by 3

[Kikishua]

Hi,

I think it's my maths skills (limited!) that are holding me up on solving this one...

I am trying to write a formula to help me round up/down to the nearest whole number that is divisible by 3. My original numbers are already rounded up/down to 2 decimal points.

I am using Excel 2010.

Example: 226.22 would round down to 225, and 226.82 would round up to 228.

Any help greatly appreciated (and I suspect this is a relatively simple one, too, if only I could get my head around the IF function better).

Thank you.

 

[adam087]

Try...

=3*ROUND(A2/3, 0)

Hope that helps.

/AJ

 

[Kikishua]

OMG! Yes, it does! And I'd never have thought of doing it like that, so am very glad I asked. Many thanks!

 

[adam087]

No probs,. happy to help. Thanks for the feedback.

/AJ