hoe can I repalce a formula with its result automatically

A

AldreteMeza

For example:

A3=days360(2006/03/12,today())

A5=if(a3=10,"10","No Data")

on 2006/03/22 I will have A5=10 but on 2006/03/23 I will have A5=No data and
I want to recall, replace the value of A5=10 at the time the expresion "if"
is true and let A5 always be 10 after expresion is "if" is true.
 
C

CLR

There are several ways, depending on how you want it to happen.......you
could just hand type the 10 over the formula and that would do the
replacement..........you could do Copy > PasteSpecial > Values.........or you
could do it by macro......or the formula could be structured to result in 10
at any time AFTER a certain date.

Vaya con Dios,
Chuck, CABGx3
 
Top