ROUNDUP increments

[Nanaia]

Is there a way to ROUNDUP in increments? For example, if A2 is 74 and I wanted the adjacent cell, A3, to round A2 to the closest foot, how would I do it?

 

[Nanaia]

I think I got it.

=(ROUNDUP(A2/12))*12

 

[steve the fish]

Nearly there:

=ROUNDUP(A2/12,0)*12

or I usually go:

=CEILING(A2,12)

 

[Nanaia]

Sweet! Thank you! Is there a way to round it by half foot?

Addendum: I just looked up that syntax. Just change the 12 to 6, right?

 

[steve the fish]

Sweet! Thank you! Is there a way to round it by half foot?

Addendum: I just looked up that syntax. Just change the 12 to 6, right?

Yes indeed.

 

[Nanaia]

Fantabulous!

Thanks again!