Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with IF statement (2003)

    Greetings all,

    Here is my if statement. I am getting a too many arguments error. What gives? any better way to write this?


    =IF(C66=28033247,U9,IF(C66="","",IF(C66=T10,U10,if (c66=t11,u11))))


    thanks,
    Brad

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with IF statement (2003)

    It works fine for me!

    Try : =IF(C66=28033247,U9,IF(C66="","",IF(C66=T10,U10,IF (C66=T11,U11,""))))
    Regards,
    Rudi

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with IF statement (2003)

    Thanks!


    Found out the prob. I had copied the cell from another similar activity, and the data validation list pointed to the old stuff.



    thanks,
    Brad

Posting Permissions

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