Results 1 to 7 of 7
Thread: If Statement Help (2007)

20080820, 07:43 #1
 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!Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

20080820, 08:16 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 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),""),"")

20080820, 08:29 #3
 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>

20080820, 08:36 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 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.

20080820, 08:40 #5
 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!Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

20080820, 08:47 #6
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 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.

20080820, 09:06 #7
 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>