Help with a formula, sorting in to catagories

Okay so, I'm trying to sort it in to age and gender categories, I entered the formula and when I clicked enter it didn't say there were any mistakes, but when I actually test if it works, it doesn't. it just comes up as "#VALUE!", This is for my ICT GCSE spreadsheet, oh and here's the formula

=IF(D5<20&AND(D7="Female"),"Female Teenager","Male Teenager"),IF(D5<51&AND(D7="Female"),"Female Adult","Male Adult"),IF(D5<150&AND(D7="Female"),"Female Over 50","Male Over 50"),IF(D5<6&AND(D7="Female"),"Female Under 5","Male Under 5"),IF(D5<11&AND(D7="Female"),"Female Child","Male Child")

ict.jpg

Thanks!

I've attached the whole file as some bits won't work if I give the singular sheet,
It's the tab called 'BMI Tracker' in Cyan, And the bit that isn't working is The category box