XxTWOBONExX
Structural
- Apr 16, 2008
- 2
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
A2+B2=C2
C1+C2=D3
When i do this i receive a value#
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
A2+B2=C2
C1+C2=D3
When i do this i receive a value#