calculate using last four digits of number in cell
 

I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.

calculate using last four digits of number in cell
 

=--right(a1,4)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Andy Falkner" <Andy wrote in message
...
I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.

calculate using last four digits of number in cell
 

try
=RIGHT(E4,4)*2

--
Don Guillett
SalesAid Software

"Andy Falkner" <Andy wrote in message
...
I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.

calculate using last four digits of number in cell
 

How about an example?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andy Falkner" <Andy wrote in message
...
I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.