Very sorry - I have posted this in another groupd and have realised
this is in fact the correct place to ask.

I am currently using the IF function to display a score value based
on
age. I am currently using 2 cells with 2 seperate equations for boys
(with age in C5):


=IF($C$5=11,10.6,IF($C$5=12,12.8,IF($C$5=13,15,IF( $C$5=14,17.2,IF($C
$5=15,19.3,IF($C$5=16,20.1,IF($C$5=17,20.9,IF($C$5 =18,21.6))))))))


and girls (with age in B5):


=IF($B$5=11,9,IF($B$5=12,10.6,IF($B$5=13,12.1,IF($ B$5=14,13.7,IF($B
$5=15,15.4,IF($B$5=16,15.8,IF($B$5=17,16.3,IF($B$5 =18,16.7))))))))


I am trying to combine the 2 equations into one, so that the user can
enter age and sex (m or f) and the output will be the appropriate
score.

I am pretty sure that I need to be using the AND / OR functions but
can't seem to crack it. Any help (as always) much appreciated!


Thanks