+ Reply to Thread
Results 1 to 3 of 3

Newbie help with simple % formula please

  1. #1
    Registered User
    Join Date
    02-05-2007
    Posts
    1

    Newbie help with simple % formula please

    Hi.

    I want to get a simple percentage of numbers.

    There are 2 numbers in the spreadsheet, and I want to see what % of the total each # represents.

    A1 + B1 = X

    A1 / X = %

    How do I represent that formula?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    02-03-2007
    Location
    Burleson, TX, USA
    MS-Off Ver
    2010
    Posts
    132
    Format the cell containing the answer to a percentage.

    mark

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    if you want a % of the total, do it like this:

    A1= number 1
    B1= number 2
    C1= total (in excel, do forumla =A1+B1)
    S1= percentage (in excel, do formula =A1/C1)

    then format the cell into percentage format
    does that answer your question?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1