Microsoft® Excel 2010 Functions

  • About Harmeet

    Harmeet

    loves to simplify technology for all readers who are interested in the genre but find it complex to comprehend. She is a writer by passion and wants to enrich the life of others by writing about the latest gadgets, apps, and devices in the simplest and the most useful manner. Her blogs are detailed, interesting, and definitely fun to read…

    1 Comment

    Be the first to comment!

    Leave a Reply
    • Ramona Ahumada

      Need help with Excel functions, trying to do a percentage on a table of data and not sure how to, con you help?
      Column1 January Febuary March April May June July August September October November December Amount totals Percentages
      Monthly Income
      Ramona's Income $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $42,000.00

      Monthly Espenses
      Rent $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $8,400.00
      Electric $125.00 $125.00 $125.00 $125.00 $130.00 $140.00 $145.00 $145.00 $140.00 $135.00 $130.00 $125.00 $1,590.00
      Gas $135.00 $140.00 $135.00 $130.00 $125.00 $120.00 $120.00 $120.00 $120.00 $125.00 $130.00 $135.00 $1,535.00
      Water $85.00 $80.00 $80.00 $90.00 $90.00 $95.00 $95.00 $95.00 $90.00 $85.00 $80.00 $80.00 $1,045.00
      Trash $40.00 $40.00 $40.00 $40.00 $50.00 $50.00 $50.00 $50.00 $50.00 $40.00 $40.00 $40.00 $530.00
      Telephone $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $720.00
      Internet $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $480.00
      Cable $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $780.00
      Car Payment $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $3,000.00
      Car Insurance $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $900.00
      Gas for Car $100.00 $100.00 $100.00 $150.00 $150.00 $150.00 $150.00 $150.00 $100.00 $100.00 $100.00 $100.00 $1,450.00
      Credit Card Pymt $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $600.00
      Child Care $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
      Medical Insurance $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $600.00
      Groceries $300.00 $300.00 $300.00 $300.00 $350.00 $350.00 $350.00 $350.00 $350.00 $300.00 $300.00 $300.00 $3,850.00
      Entertainment $300.00 $300.00 $300.00 $300.00 $400.00 $400.00 $400.00 $400.00 $400.00 $300.00 $300.00 $300.00 $4,100.00

      Total Expenses $2,475.00 $2,475.00 $2,470.00 $2,525.00 $2,685.00 $2,695.00 $2,700.00 $2,700.00 $2,640.00 $2,475.00 $2,470.00 $2,470.00 $30,780.00


      1 Reply »

      ashish.ashish

      Ramona,

      You need percentage for what?

      This is how we normally calculate percentage:
      Example: If A1 is 10 and A2 is 100 and you want to find what percentage of A2 is A1, the folmula would be '=A1/A2'. You would also have to change the format of this cell. You can chage the format of cell by doing the following:
      - right click on the cell
      - click on format cell
      - on the number tab, select percentage on the left and on the right select the number of decimal places.

      All the best!!!
      **********************
      iYogi - Good Karma!!!!


      0 Replies »

    Name: *
    E-mail: *
    Website:
    Comments: *
     

    Call Toll Free 1 877 889 6860
    Annual Unlimited Tech Support for just $179.99 per one PC