View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default Unwanted Rounding


you need to include your formula in another function

eg if your original formula was sum(a1:a2)

eg rounddown(sum(a1:a2),2)
or floor(sum(a1:a2),0.01)

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545412