Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If Statement Help (2007)

    G'day Loungers!
    I have been looking at this if statement for 2 hours now and cannot see what is wrong. Can anyone help?
    IF(N2<>"",IF(T2<>"Exempt",(IF((T2+H2)>U2,IF(H2>=U2 ,H2,U2),T2+H2),""),"")

    Excel just says there is an error in the formula. The formula goes in cell V2.
    I have attached a sample workbook with the data in it.

    Thanks in advance!
    Attached Files Attached Files
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Statement Help (2007)

    The actual formula in your workbook is different:

    =IF(N2<>"",IF(T2<>"Exempt",(IF T2+H2>U2,IF(H2>=U2,H2,U2),T2+H2),""),"")

    As you can see there is no ( between IF and T2+H2. Perhaps you meant

    =IF(N2<>"",IF(T2<>"Exempt",IF(T2+H2>U2,IF(H2>=U2,H 2,U2),T2+H2),""),"")

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Statement Help (2007)

    Hans, My apologies. The workbook would not let me save the actual formula because of the error in it. The formula I included in the original post is the one giving the error. Even making the correction you suggested I still receive the error box. When I click OK the entire formula is highlighted in the formula bar.

    Maybe a better explanation of what I am attempting to do will help. I am calculating wage increases based on the score in column N. Certain tasks are not eligible for increase and are marked as Exempt in column T. If the task is eligible then the formula in T calculates the amount of increase based on the score in N and the scales which I did not include on the original attachment. I now need to see if the new wage (increase plus base) exceeds the maximum allowable wage for that task which is in column U. If the max wage is equaled or exceeded then column V should list the max wage else it should list the new calculated wage.

    Does that help?
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Statement Help (2007)

    Could you attach a workbook that does not contain links to an external workbook and that contains some values that we can actually use? Thanks.

  5. #5
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Statement Help (2007)

    Hans,

    Try this one. I pasted the values where there were external links.
    thanks!
    Attached Files Attached Files
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Statement Help (2007)

    See the attached version. If the formula doesn't do what you want, please explain why not, and what you expected the result to be.
    Attached Files Attached Files

  7. #7
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Statement Help (2007)

    Hans, Perfect as usual. I didn't think of using the Max function when I was drawing this out.
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

Posting Permissions

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