Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF Problem (Excel 2002)

    Hi

    I can only count 7 IF's here but Excel is complaining the there are too many arguments


    =IF(AV40>4300,AV40-BM2,"",IF(AV40>3000,AV40-BM3,"",IF(AV40>2000,AV40-BM4,"",IF(AV40>1000,AV40-BM5,"",IF(AV40>800,AV40-BM6,"",IF(AV40>430,AV40-BM7,"",IF(AV40>200,AV40-BM8,"")))))))

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Problem (Excel 2002)

    Hi

    I am as my signature say a fool , too many "" ""

    Sorry to have bothered anybody

    Braddy
    If you are a fool at forty, you will always be a fool

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts

    Re: IF Problem (Excel 2002)

    Do you mean:
    =IF(AV40>4300,AV40-BM2,IF(AV40>3000,AV40-BM3,IF(AV40>2000,AV40-BM4,IF(AV40>1000,AV40-BM5,IF(AV40>800,AV40-BM6,IF(AV40>430,AV40-BM7,IF(AV40>200,AV40-BM8,"")))))))

    This has nothing to do with the number of IFs.

    An IF is:
    =if(condition, truepart, falsepart)

    You have:
    =if(condition, truepart, "", falsepart)

    and I removed the null...

    Note: With this type of setup I would prefer to create a table and use Vlookup. It is easier to edit later, more clear, and does not have the limit to the number of IFs (see Excel User Tip: Alternatives to Nested IF Functions for an example)

    Steve

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Problem (Excel 2002)

    Hi Steve

    Thanks for your reply. I realised my error soon after posting.

    Thanks for the advice I have downloaded it and see if I can put it use.


    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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