Results 1 to 3 of 3
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    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)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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$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. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    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 Hans
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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