[dba-Tech] Excel question

Max Wanadoo max.wanadoo at gmail.com
Tue Jan 5 12:43:11 CST 2010


Wot 'bout a function to do the same?

Max


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jon Tydda
Sent: 05 January 2010 18:31
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Excel question

Except it won't. The problem with Excel is auto-calculation. Every time A7
changes, this cell will update to the present value. I'm not sure there's a
way to do it without manually entering the data once it's there, or
Copy/Paste Special Values.


Jon

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: 05 January 2010 18:21
To: 'Discussion of Hardware and Software issues'
Subject: Re: [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

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

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




More information about the dba-Tech mailing list