View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moonhk moonhk is offline
external usenet poster
 
Posts: 62
Default 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.