View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default hoe can I repalce a formula with its result automatically

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.