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

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

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