Posted by Juan Pablo G. on January 18, 2002 11:52 AM

Posted by Dixie on January 18, 2002 12:12 PM

Posted by Dixie on January 18, 2002 12:18 PM

Here is my problem.. I am trying to get this formula to work

=IF(K3<68400,K3*0.062,0)

But I need to get Excel to work with the last number of the employee number (A1)... What I need it to do is if the employee number has a 1 at the end then do the above formula if not then do another formula

=IF((K4*L4)< 68400,K4*L4*0.062,0)

HELP!!!!!!

Posted by Dixie on January 18, 2002 12:23 PM

Posted by Juan Pablo G. on January 18, 2002 12:29 PM

Easy, don't need to post same thing 3 times...

Try with

=IF(RIGHT(A1)=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062

Juan Pablo G. : Here is my problem.. I am trying to get this formula to work : =IF(K3<68400,K3*0.062,0)

Posted by Aladin Akyurek on January 18, 2002 1:06 PM

=IF(RIGHT(A1)+0=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062

Aladin

======= Try with =IF(RIGHT(A1)=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062

Posted by Juan Pablo G. on January 18, 2002 1:09 PM

=IF(RIGHT(A1)+0=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062 Aladin ======= : Try with : =IF(RIGHT(A1)=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062

Posted by Dixie on January 18, 2002 2:25 PM

When I used the formula that Juan suggested it came up with 000...When I put in the formula from Aladin it gave me an #value error!! Any more suggestions... All are very much appreciated...

times... : =IF(RIGHT(A1)+0=1,(K3 < 68400)*K3,(K4*L4 < 68400)*K4*L4)*0.062 : Aladin : =======

Posted by Aladin Akyurek on January 18, 2002 3:21 PM

Lets see: You have a number in A1 whose last digit is of interest.

Try:

=0.062*IF(AND(LEN(A1),RIGHT(A1)+0=1),(K3<68400)*K3,((K4*L4)< 68400)*K4*L4)

Aladin