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