1. 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.

2. 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. 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?

4. 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. Re: If Statement Help (2007)

Hans,

Try this one. I pasted the values where there were external links.
thanks!

6. 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.

7. Re: If Statement Help (2007)

Hans, Perfect as usual. I didn't think of using the Max function when I was drawing this out.

Posting Permissions

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