OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.