Howdy,
This is what i am trying to do
300inches x 96 inches = 28800 sq in
218 inches x 96 inches = 20736 sq in
28800+20736=49536 sq in
49536 sq in convert to sq feet=344sq ft
344 sq ft / 116.25=2.95914
Round up=3
Is there a formula?
Hi folks,
I have taken this formula =(A1)&"'-"&TRIM(TEXT(ROUND(MOD(A1,1)*12*16,0)/16,"# ??/??")&"""")
which converts from decimal to feet and inches.
What i am trying to do is to take the answer to each one of these cells and add them together for a grand total.
for instances A1+B1=C1...
