How to amend formula ?

M

moonhk

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.
 
T

Tom Ogilvy

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.
 
M

moonhk

It works. Thank a lot.

=B1+0.02+0.02

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

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a greater than but less than formula in excel? 2
Add Chr(10) to cell 2
Amend code 1
Trying to return Range from InputBox 3
How to set cell value to emptry if three other columns are empty too 1
How to change multiple formulae by looping 1
INT to ROUNDUP 5
simple code but it doesn't look like usual vba code 2

Top