• Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Results 1 to 4 of 4

    Thread: Excel formula help

    1. #1
      Moxie's Avatar
      Moxie is offline Platinum Member
      Points: 2,538, Level: 30
      Level completed: 59%, Points required for next Level: 62
      Overall activity: 0%
      Achievements:
      1 year registered1000 Experience Points
      This user has no status.
       
      I am:
      ----
       
      Join Date
      Mar 2011
      Posts
      181
      Post Thanks / Like
      Points
      2,538
      Level
      30
      Rep Power
      14

      Default Excel formula help

      Looking for an excel genius to help me out...any of you bros really good with it? I'm designing a spreadsheet in excel where I enter skinfold values (thickness of each skinfold site in mm). I have already set it up so that excel takes the average of the two trials at each site and sums the averages. Now the sum of skinfolds is entered into a different formula (I'm using the Jackson-Pollack 7 site method) based on whether the subject is male or female.

      Here's my question:

      Is there any way to set up a cell that uses one formula when the subject is male, and a different formula when the subject is female? Can I set something up where I enter "Male" or "Female" into a certain cell, and then based which word is entered into that cell, the cell displaying the %BF uses the appropriate formula? Hope that makes sense....

    2. #2
      Moxie's Avatar
      Moxie is offline Platinum Member
      Points: 2,538, Level: 30
      Level completed: 59%, Points required for next Level: 62
      Overall activity: 0%
      Achievements:
      1 year registered1000 Experience Points
      This user has no status.
       
      I am:
      ----
       
      Join Date
      Mar 2011
      Posts
      181
      Post Thanks / Like
      Points
      2,538
      Level
      30
      Rep Power
      14

      Default Re: Excel formula help

      Figured it out guys..../thread

    3. #3
      ketsugo is offline Banned
      Points: 6,374, Level: 52
      Level completed: 12%, Points required for next Level: 176
      Overall activity: 4.0%
      Achievements:
      Recommendation Second ClassVeteran5000 Experience Points
      This user has no status.
       
      I am:
      Poorly
       
      Join Date
      Feb 2007
      Location
      PATS TOWN ,USA
      Posts
      0
      Post Thanks / Like
      Points
      6,374
      Level
      52
      Rep Power
      0

      Default Re: Excel formula help

      So are you a computer whiz too? Lmao

    4. #4
      Moxie's Avatar
      Moxie is offline Platinum Member
      Points: 2,538, Level: 30
      Level completed: 59%, Points required for next Level: 62
      Overall activity: 0%
      Achievements:
      1 year registered1000 Experience Points
      This user has no status.
       
      I am:
      ----
       
      Join Date
      Mar 2011
      Posts
      181
      Post Thanks / Like
      Points
      2,538
      Level
      30
      Rep Power
      14

      Default Re: Excel formula help

      haha google works wonders brotha!

    Thread Information

    Users Browsing this Thread

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

    Posting Permissions

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