1. ## 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?

2. ## 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\$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.

3. ## 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 Hans

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•