Posted to microsoft.public.excel.programming

moonhk

external usenet poster

Posts: 62

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amend Formula	colin	Excel Discussion (Misc queries)	8	July 13th 09 12:36 PM
amend formula	[email protected]	Excel Discussion (Misc queries)	1	August 20th 08 05:02 AM
Amend the Code	shan_in_dubai	Excel Programming	1	July 19th 05 09:36 AM
Amend formula to include addition condition	Pat	Excel Worksheet Functions	1	March 16th 05 03:36 PM
Amend code	gavmer[_75_]	Excel Programming	1	September 22nd 04 12:57 AM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us