Thread: calculate using last four digits of number in cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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.


Reply With QuoteReply With Quote