[dba-Tech] Excel question

What about,

If(A5=0,A5=A7)

So it only takes the value once.  Sommat like  that.

Max


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik
Sent: 05 January 2010 17:14
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] Excel question

Hi, and Happy New Year,

I cannot find the following function in Excel:
I have a formula in one cell and want to convert it to the present value.
example:
A5 contains formula =A7
A7 contains 500 therefore I see 500 in A5
I need to do something with A5 so that it contains 500 even if I change A7 
to 0
no, I do not want to retype 500 into A5.

thanks
Lembit 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com