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.

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



"AldreteMeza" wrote:

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.