MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulling out a number


Posted by Dixie on January 18, 2002 11:46 AM

I am working on a project and I am stumped... I am trying to figure out a way for excel to only see the last number in a series of numbers.. for example...
2319584761.. The one is an employee code standing for hourly pay.. How do I get excel to let me work in a formula only using the 1.. Any help would be appreciated...


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

=RIGHT(A1)

Juan Pablo G.

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

Thank you so much.....

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

HELP


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

Re: HELP

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

Juan means...

=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

Thanks Aladin (NT)

=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

Didn't work!!!

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

Re: Didn't work!!!

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