Results 1 to 3 of 3
Thread: Formula Help (MSO2003)

20060203, 20:38 #1
 Join Date
 Dec 2001
 Location
 Chandler, AZ
 Posts
 2,160
 Thanks
 45
 Thanked 13 Times in 11 Posts
Formula Help (MSO2003)
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?Thanks John
Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

20060203, 20:48 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Formula Help (MSO2003)
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$74,$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$79,$F$23,$F$24),"")
The first argument of the CHOOSE function should always have values starting at 1.

20060203, 20:58 #3
 Join Date
 Dec 2001
 Location
 Chandler, AZ
 Posts
 2,160
 Thanks
 45
 Thanked 13 Times in 11 Posts
Re: Formula Help (MSO2003)
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 HansThanks John
Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)