Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add whole numbers to fractions?
I am trying to produce a chart that will add up FT-IN, is this possible with
Excel? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add whole numbers to fractions?
If you are starting with feet in decimal form, say A1 contains 12.1, then
=INT(A1)&"' "&INT(12*(A1-INT(A1)))&""" "&TEXT(MOD(12*(A1-INT(A1)),1),"##/##") will display 12' 1" 1/5 as feet-inches-fractional inches If you are starting out with feet and inches, then put them in separate cells. -- Gary''s Student gsnu200709 "aw" wrote: I am trying to produce a chart that will add up FT-IN, is this possible with Excel? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add whole numbers to fractions?
I generally enter such measurements in the form 2 4/12 (I format the range
with custom format # ??/12 to prevent Excel making this 2 1/3) Such values can be mathematically manipulated (summed, averaged, etc) For a alternatives see http://www.cpearson.com/excel/fractional.htm http://www.cpearson.com/excel/FeetInches.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aw" wrote in message ... I am trying to produce a chart that will add up FT-IN, is this possible with Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fractions | Excel Worksheet Functions | |||
Formatting Numbers and Fractions in Excel | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) |