Anthony, et al.
I just reread what I sent out and it in no way indicated what I was
looking for. Please color me dumb.
I have a table of conversion from fractions to decimals. I'm looking
for a way to make a copy of this table and keep it in my computer as
well as make copies to keep it in my basement shop so I can refer to
it when using my numbered drills along with other small stuff such as
wire cable. Tried to use a spread sheet but as I entered the
fractions at first they were as I typed them , then they came out
like decimals, after reentering them they came out as dates, i.e.
9/16 ===09/16/07. I don't know how to fix that . So I abandoned the
spread sheet.
.Now I'm looking for a way to set up a table to enter the fractions
on one side and the decimals on the other but Using two sets of three
columns.
Anthony, I'm totally overwhelmed by what you sent and I have no idea
of what you mean. I wish to thank you and the others for your help.
thanks again
Vince
Hi Vince,
This should get you started. Below are the first fifteen rows of
columns A to E with formulae displayed. Enter the first two rows
below, then use fill down to get as many fractional numbers as you
would like in your chart. The result is below the formula list.
Select all, copy and paste special with all checked except
'formulas'. Sort the data by column 'E'. Delete all the rows that
evaluate to 1.0000.
1 / 1 = =A1/C1
=IF(A1=C1;1;A1+1) / =IF(A2=1;C1+1;C1) = =A2/C2
=IF(A2=C2;1;A2+1) / =IF(A3=1;C2+1;C2) = =A3/C3
=IF(A3=C3;1;A3+1) / =IF(A4=1;C3+1;C3) = =A4/C4
=IF(A4=C4;1;A4+1) / =IF(A5=1;C4+1;C4) = =A5/C5
=IF(A5=C5;1;A5+1) / =IF(A6=1;C5+1;C5) = =A6/C6
=IF(A6=C6;1;A6+1) / =IF(A7=1;C6+1;C6) = =A7/C7
=IF(A7=C7;1;A7+1) / =IF(A8=1;C7+1;C7) = =A8/C8
=IF(A8=C8;1;A8+1) / =IF(A9=1;C8+1;C8) = =A9/C9
=IF(A9=C9;1;A9+1) / =IF(A10=1;C9+1;C9) = =A10/C10
=IF(A10=C10;1;A10+1) / =IF(A11=1;C10+1;C10) = =A11/C11
=IF(A11=C11;1;A11+1) / =IF(A12=1;C11+1;C11) = =A12/C12
=IF(A12=C12;1;A12+1) / =IF(A13=1;C12+1;C12) = =A13/C13
=IF(A13=C13;1;A13+1) / =IF(A14=1;C13+1;C13) = =A14/C14
=IF(A14=C14;1;A14+1) / =IF(A15=1;C14+1;C14) = =A15/C15
This is what it looks like before sorting.
1 / 1 = 1.00000
1 / 2 = 0.50000
2 / 2 = 1.00000
1 / 3 = 0.33333
2 / 3 = 0.66667
3 / 3 = 1.00000
1 / 4 = 0.25000
2 / 4 = 0.50000
3 / 4 = 0.75000
4 / 4 = 1.00000
1 / 5 = 0.20000
2 / 5 = 0.40000
3 / 5 = 0.60000
4 / 5 = 0.80000
5 / 5 = 1.00000
If you don't want every every denominator, you'll have to be more
creative in the formulae.
tc
Vincent A Juliano wrote:
I'm having no luck using a spread sheet.
In the tutorials where is there information to set up a table that
will show the fraction and the corresponding decimal? I'd like to
use six small columns for clarity.
Thank you
Vince
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]