+ Reply to Thread
Results 1 to 4 of 4

Can anyone help me solve these problems?

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Belpre, Ohio
    MS-Off Ver
    microsoft office 2013
    Posts
    3

    Can anyone help me solve these problems?

    I don't know what functions to use....PLEASE HELP!
    1. Enter a conditional function in cell M4 to calculate the total membership fees paid by members 25 years old or younger.
    2. Enter a similar function in cell M5 to calculate the total number of membership fees paid by members over the age of 25. Format the results in M4 and M5 with Accounting Number Format.
    3. Enter a similar function in cell L10 that calculates the total number of members over the age of 25 that lost at least 5 pounds.
    4. Enter a function in cell H4 that calculates the rank of the weight loss in cell G4 against the range of individual weight lost in the data set.
    Use the fill handle to copy the function down column H. Be sure to include the appropriate absolute or mixed cell references before copying the functions.

    THANKS TO ANYONE WHO CAN HELP!!!!!

  2. #2
    Registered User
    Join Date
    10-29-2014
    Location
    Needham, MA
    MS-Off Ver
    2010
    Posts
    4

    Re: Can anyone help me solve these problems?

    How about an IF formula that looks at the value of the age field to then determine a calc. for example IF(m3>25,2400,0) where m3 is the age. Similarly you could use the same function types in the other examples.

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    Belpre, Ohio
    MS-Off Ver
    microsoft office 2013
    Posts
    3

    Re: Can anyone help me solve these problems?

    So, I would put (c4:c53>25, and what would I put under 2400?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,962

    Re: Can anyone help me solve these problems?

    Welcome to the Forum, unfortunately:

    This is a duplicate post (here) and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help for IF Function to solve my excel problems
    By G_A_S in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2013, 02:48 AM
  2. Hear to learn VBA mysteries and solve some problems
    By Denison in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-30-2013, 05:51 AM
  3. Replies: 3
    Last Post: 09-09-2012, 10:45 AM
  4. 2 problems to solve - Automatically generated template
    By Maraug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2012, 10:46 AM
  5. solve Sorting problems...
    By Gunnett in forum Excel General
    Replies: 2
    Last Post: 06-28-2007, 03:17 PM

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