Results 1 to 1 of 1

Excel 2007 : Finding percentages?

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Finding percentages?

    I'm currently working on a little project to help me track of the protein/carbs/fat in the foods I eat. I have all my dropdown lists working and everything it totalling and changing like it's supposed to so I decided today that it would be nice to take the total p/c/f totals and in the cell below each, show what percentage it represents. For example, one iteration of the diet I'm on is 50% protein 30% carbs 20% fat and I was hoping to add the percentages below the totals to help keep me aware of how close I am to what I need to be.

    The problem I'm running into is that I'm very new to excel and am still fumbling my way around tutorials. It seems that I need to get a total for the 3 cells then calculate the percent for each cell. At the moment my "totals" are in C15/D15/E15. Is there a way I can calculate the percentage that, say, C15 is of the 3 cells and display it below in C16 without too much fuss? Thank you very much.


    Edit: Sorry to bother you guys, I sorted it out
    Last edited by bscruggs99; 03-06-2011 at 03:15 PM.

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