Help with Rounding up a formula to a whole number

[wberg82]

=IF(MOD((J29*1.1),12)>=9,CEILING((J29*1.1),12),(J29*1.1))

This current formula I am using is not working the way I want it to. Here is what I am trying to do:

I want the user to enter a number in cell J29. Cell B29 then takes that number and multiplies it by 10%. The result of that number rounds up to the next interval of 12. However, here is where it gets complicated (at least in my eyes).

It only rounds up to the next interval of 12 after the result equals or greater than a certain result of the multiplication, otherwise the output will be that (whole) number. For example:

If user enters "3" in cell J29, the result of the above equation is 3.3. This number needs to round up to 4. However, if the result is greater than or equal to 9, I want the output to round up to 12.

If result is >=9 output is 12
If result is >=20 output is 24
If result is >=30 output is 36
If result is >=42 output is 48

Any help on this would be greatly appreciated.

Thanks!

 

[SpillerBD]

test this:

=IF(MOD((J29*1.1),12)>=9,MROUND((J29*1.1),12),ROUNDUP(J29*1.1,0))