Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!' (http://s26.yousendit.com/d.aspx?id=2...J0UU7K66DTQJQB ) Thanks!! :( :( :( :( :( :( -- aeiou ------------------------------------------------------------------------ aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595 View this thread: http://www.excelforum.com/showthread...hreadid=390139 |
#2
|
|||
|
|||
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 +-------------------------------------------------------------------+ |Filename: Prob2.zip | |Download: http://www.excelforum.com/attachment.php?postid=3630 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390139 |
#3
|
|||
|
|||
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. -- aeiou ------------------------------------------------------------------------ aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595 View this thread: http://www.excelforum.com/showthread...hreadid=390139 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Functions - question using formulas as criteria | Excel Worksheet Functions | |||
Formulas & Functions | Excel Discussion (Misc queries) | |||
Functions and formulas | Excel Discussion (Misc queries) | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions |