SUBSCRIBE  |  PREFERENCES MY LINKS:              chat center STATES  |  GRADE LEVEL  |  SUBJECTS

Computer Teachers Chatboard

TOP POSTS ALL POSTS SUBMIT POST
Search Teachers.Net
Advanced

Advertise with Teachers.Net - Rate Card, Demographics, etc. Live Chat - Online Teacher Meetings and Workshops Harry Wong - Effective Teaching Teachers.Net Gazette - Articles by Teachers, For Teachers Mailrings - Teacher Email  Discussion Lists Teaching Jobs - Free Job Listings for Classroom Teachers Teacher Classified Ads K-12 Classroom Projects Lesson Plans - Over 4000 Free Lesson Plans Teacher Chatboards - Discussion Forums for Teachers Teacher Chat - Over 150 Teacher Discussion Topics
next post skip topic



Print | Share | Report Post

    Re: Excel help
    Posted by East End Long Islander on 10/08/08

    The first cell (A1) put in 2000.
    The second cell (A2) put in =SUM(6000/10)+A1
    .. That will show as 2600.
    Highlight and copy the formula.
    Then highlight rows A3 to A11, and Paste. The formula will
    copy from cell to cell and display like this:
    2000
    2600
    3200
    3800
    4400
    5000
    5600
    6200
    6800
    7400
    8000

    That's for 11 rows (you said 10 more).\

    ********

    If you want it for ONLY 10 rows, change the formula to
    =SUM(6000/9)+A1. Follow the rest of the directions the same
    way. It will display like this:

    2000
    2666.666667
    3333.333333
    4000
    4666.666667
    5333.333333
    6000
    6666.666667
    7333.333333
    8000

    RESPOND TO THIS POST START A NEW THREAD RETURN TO CHATBOARD

    Posts on this thread, including this one

  • Excel help, 10/08/08, by Susie.
  • Re: Excel help, 10/08/08, by East End Long Islander.

     
     

You are on the COMPUTERS CHATBOARD:   LATEST POSTS   ALL POSTS   SUBMIT POST

Other Chatboards in this Category...

Check out our latest FREE Lesson Plans...
 
Google
 
Web Teachers.Net
Click here
  Site Map: Home Search Teaching Jobs Classifieds Lesson Plans Contacts PR AdvertiseSite Map
  © 1996 - 2008. All Rights Reserved. Please review our Terms of Use, Mission Statement, and Privacy Policy.