Inches to be rounded up to next foot

[craigwojo]

I need a way to have the number input be automatically updated to the next foot increment.
ex. If 2 was inputted, it would have a value of 12. If 26 was the input, it would have a value of 36 (being that 2' 2" (26")) would go to 3', and so on. This is based on English foot and inches.

Thank you,
Craig

 

[igold]

If your number was is Cell A1, does this formula placed in another cell work for you:

=IF(MOD(A1,12)=0,A1,FLOOR(A1/12,1)*12+12)

 

[Dave Patton]

T202009c.xlsm
	A	B	C
1	Inches	Feet	Inches
2	2	1	12
3	11	1	12
4	12	1	12
5	13	2	24
6	26	3	36
7	154	13	156
8
3c

Cell Formulas
Range	Formula
B2:B7	B2	=ROUNDUP(DOLLARFR(A2/12,12),0)
C2:C7	C2	=B2*12

 

[igold]

If I misread your needs and you wanted the number in feet you could use:

=IF(MOD(A1,12)=0,A1,FLOOR(A1/12,1)*12+12)/12

 

[Tetra201]

Even shorter:

=ROUNDUP(A2/12,0)*12 (2 in --> 12 in)
=ROUNDUP(A2/12,0) (2 in --> 1 ft)

 

[igold]

@Tetra201

You'll not return the correct answer for even multiples of 12.

 

[Tetra201]

... You'll not return the correct answer for even multiples of 12.

???

 

[igold]

On my sheet your formula changed 12 to 24, 24 to 36 etc...

 

[Tetra201]

The formulas from Post # 5 have been tested to return the expected results on:
- Excel 2010 / Win 7
- Excel 2011 / OS X 10.9.5
- Excel 365 / Win 10

 

[craigwojo]

If I misread your needs and you wanted the number in feet you could use:

=IF(MOD(A1,12)=0,A1,FLOOR(A1/12,1)*12+12)/12

Thank you igold