How to amend formula ?
 

Dear Reader
How to amend formula ?
If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
=Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
This Value range maybe +0.05 to -0.05.

Provide that I does not know the existing formula of particluar cell.

How to amend formula ?
 

ActiveCell.Formula = ActiveCell.Formula & "+.02"

I have no idea what you mean by "Roundup different value", but hopefully
that won't affect the usefulness of the answer.

--
rEgards,
Tom Ogilvy



"moonhk" wrote in message
oups.com...
Dear Reader
How to amend formula ?
If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
=Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
This Value range maybe +0.05 to -0.05.

Provide that I does not know the existing formula of particluar cell.

How to amend formula ?
 

It works. Thank a lot.

=B1+0.02+0.02

Sub testing()
ActiveCell.Formula = ActiveCell.Formula & "+.02"

End Sub

Tom Ogilvy wrote:
ActiveCell.Formula = ActiveCell.Formula & "+.02"

I have no idea what you mean by "Roundup different value", but hopefully
that won't affect the usefulness of the answer.

--
rEgards,
Tom Ogilvy



"moonhk" wrote in message
oups.com...
Dear Reader
How to amend formula ?
If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
=Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
This Value range maybe +0.05 to -0.05.

Provide that I does not know the existing formula of particluar cell.