Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!

hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met.
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!

Hi,

Thanks for the reply!

Is there any excel code that allows me to do that? If not any idea how do I
write the macro code for this function?

Thanks!



"FSt1" wrote:

hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met.
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!

On 20 Apr, 08:04, Lim wrote:
Hi,

Thanks for the reply!

Is there any excel code that allows me to do that? If not any idea how do I
write the macro code for this function?

Thanks!



"FSt1" wrote:
hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met. *
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

*Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!- Hide quoted text -

- Show quoted text -

Lim

Don’t know if I understand your question fully based on what
information you have given, but here is my shot.

If you AVERAGE() calculation is in say F19
If your target date is in say E4
If you want to show the result of the AVERAGE calculation in F20,
place this formula: =IF(E4TODAY(),"",F19)

Is this even close?

Mike Rogers

Lim

Dont know if I understand your question fully based on what
information you have given, but here is my shot.

If you AVERAGE() calculation is in say F19
If your target date is in say E4
If you want to show the result of the AVERAGE calculation in F20,
place this formula: =IF(E4TODAY(),"",F19)

Is this even close?

Mike Rogers




On 20 Apr, 08:04, Lim wrote:
Hi,

Thanks for the reply!

Is there any excel code that allows me to do that? If not any idea how do I
write the macro code for this function?

Thanks!



"FSt1" wrote:
hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met.
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!- Hide quoted text -

- Show quoted text -

Lim

Dont know if I understand your question fully based on what
information you have given, but here is my shot.

If you AVERAGE() calculation is in say F19
If your target date is in say E4
If you want to show the result of the AVERAGE calculation in F20,
place this formula: =IF(E4TODAY(),"",F19)

Is this even close?

Mike Rogers