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]