Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc. When i try to drag the fill handle down it gives me all kinds of odd results. e.g.-1/8, -1/5, -2/7 etc. Any ideas on how to get Excel to just continue the series?

Thanks!

share|improve this question

Make it into three columns.

Make a nominator column, and a denominator column. Then make a column with the formula.

1  3  =1/3
1  4  =1/4
1  5  =1/5
1  6  =1/6
1  7  =1/7

If it's not a regular interval it excel won't be able to intuit the pattern.

share|improve this answer
    
I must be particlarly thick today. 1 in a1 3 in b1 and what exactly in c1? – Auto Aug 3 '10 at 2:14
1  
@Auto in C1: =A1/B1 – box9 Aug 3 '10 at 3:06
    
+1 to dtang. Format c1 as a fraction in "format cells" (CTRL+1) and it'll work. I tested it. – JNK Aug 3 '10 at 10:30
    
Forgot to thank... my bad. So, THANK YOU! – Auto Oct 28 '10 at 23:34
    
@Auto - Happy to help. If it worked for you, please accept the answer. – JNK Oct 29 '10 at 2:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .