Results 1 to 20 of 20

which formula should i use to Calculate How many members?

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    which formula should i use to Calculate How many members?

    Hi
    I'm newbie in excel.I have a problem to ask..Hope someone can help me.

    My Data is
    Budgeted amount Spent amount
    My 1517 1836
    Mom 1839 1417
    Dad 1195 1931
    Brother 1718 1822
    Sister 1384 1939
    Aunt 1860 1305
    Uncle 1666 1315

    I know how to calculate how many members are in the list but i'm getting problem to calculate how many members have exceeded the budget.here, we can see that "MY","Dad","Brother" and "Sister" have clearly exceeded the budget but how can i do in excel, i mean which formula i should i use.
    please help me to solve this problem.Thanks in advance to anyone who will take the time to help me..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hello to every Members
    By vrs_20 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-18-2015, 07:01 AM
  2. [SOLVED] I am in need of a formula, that tells me the attendance of Club members.
    By C21thirlmere in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-22-2015, 11:27 AM
  3. Formula to identify from list team members not playing
    By cph8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2015, 03:34 PM
  4. Replies: 3
    Last Post: 11-14-2014, 09:39 PM
  5. Replies: 7
    Last Post: 03-29-2013, 04:42 PM
  6. Replies: 3
    Last Post: 10-02-2012, 03:30 PM

Tags for this Thread

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