If Statement Help (2007)

Topic

New Reply

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!

Reply | Quote

Replies

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,H2,U2),T2+H2),””),””)

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

Hans,

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote