+ Reply to Thread
Results 1 to 3 of 3

What Formulas or Functions to use??!!!

  1. #1
    Registered User
    Join Date
    07-26-2005
    Posts
    6

    What Formulas or Functions to use??!!!

    I have been struggling with my excel. Can someone tell me how and what i can do find the fees earned monthly(13/3 weeks) for each child? The family's income and number of children affect the fees each child's fee. (Assumption: All family's children are 2-5 years old with 2 parents)

    *Maximum charge for each child is $300 and the minimum is $40 a month.

    EXCEL FILE...CLICK HERE!

    Thanks!!

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    I think this fomula should work for you:
    =INDEX($O$4:$R$14,MATCH(VLOOKUP(O17,$H$2:$L$31,3,0),$N$4:$N$14,1),MATCH(VLOOKUP(O17,$H$2:$L$31,4,0)-2,$O$3:$R$3,1))*VLOOKUP(O17,$H$2:$L$31,5,0)*$L$39

    I had to alter some of the texts to make the formula work - but nothing major.

    Also see the attached zip-file: http://www.excelforum.com/attachment...tid=3630&stc=1

    Hope it helped
    Ola Sandström
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-26-2005
    Posts
    6
    OMG! How can i thank you?! The formula is a long one...o.O"...lolz. Greatly appreciated!! I'll learn how to use Vlookup ^^;.....or rather i must learn it...haa.
    Last edited by aeiou; 07-26-2005 at 11:31 PM.

+ Reply to Thread

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