Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Percent problem (Excel 2002/xp)

    I need some help with calculating survey results. 60 people responded to the survey. The professor needs to know what percent of 60 responded to each of the questions. I am not sure how to do this. See attached.
    Many thanks.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percent problem (Excel 2002/xp)

    Edited to indicate need for formating as percent.
    Melanie,

    To make the formula in B4 that refers to the result in B3, make Cell B4 active, press =B2/60 and press enter.
    Then you should format the cell as percent (look at the menu bar for the % sign).
    You can then copy this formula and paste below each result you wish to get the percentage for.


    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •