Formula Help (MSO2003)

[t8ntlikly]

I have the following formulas:
#1:=IF($B$7<5,CHOOSE($B$7,$F$6,$F$7,$F$8,$F$9),"")
#2:=IF(AND($B$7>4,($B$7<10)),CHOOSE($B$7,$F$13,$F$ 14,$F$15,$F$16,$F$17),"")
#3:=IF(AND($B$7>9,($B$7<12)),CHOOSE($B$7,$F$23,$F$ 24),"")
Formulas 1 and 2 work perfectly, yet formula 3 does not work. I get a "Value" return
Am I missing something here?

[HansV]

Formula 2 probably doesn't do exactly what you want either, I think it should be

=IF(AND($B$7>4,$B$7<10),CHOOSE($B$7-4,$F$13,$F$14,$F$15,$F$16,$F$17),"")

and formula 3 should be

=IF(AND($B$7>9,$B$7<12),CHOOSE($B$7-9,$F$23,$F$24),"")

The first argument of the CHOOSE function should always have values starting at 1.

[t8ntlikly]

Actually formula #2 does work like I want it to, but when I added the (-) to formula 3 it then worked. Taking that into account I added the (-) to Formula 2 as well. Better to be safe than sorry.
Thanks Hans