Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    if statement (2003)

    Hello,

    I am trying to write an if statement and I am having problems. The columns in excel are claim ID,code,desc,and allowed amt. Here is what I am wanting...if desc =no auth and code<>a and the claim id on the next line = claim id on previous row and code on next line <>a then bring back allowed amt. here is what I have =IF(AND(V853="No Authorization",O853<>"A",M853=M854,O854<>"A"),W853 ,"")

    V=desc,O=code,claimid=M, and W =allowed amt

    thanks

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: if statement (2003)

    That looks OK to me based on your description - how is it not working?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: if statement (2003)

    there are instances where the next line is not the same claim number so on those I need to evaluate where desc=no auth and code <>a to bring back the allowed amt. If the next line is the same claims number then I need it to evaluate more things . Here is what I have come up with but it is still not working.

    =IF(AND(L2<>L3,V2="No Authorization",O2<>"A",W2),IF(AND(L2=L3,V2="No Authorization",O2<>"A",O3<>"A"),W2,""))

    l=claim number,v=desc,o=code,and w=allowed amt . I am getting nothing but blanks and false from the results.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: if statement (2003)

    I think you want this:
    <code>=IF(AND(V2="No Authorization",O2<>"A"),IF(OR(L2<>L3,AND(L2=L3,O3< >"A")),W2,""),"")</code>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: if statement (2003)

    I will see what I get.

Posting Permissions

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