Check out this link. It may or may not help...

http://www.mcgimpsey.com/excel/pennyoff.html
--
HTH...

Jim Thomlinson


"plantslayer" wrote:

I have two Excel worksheets. One is the summary document, the other is the
cash flow. The cash flow is out by $0.02, because of who excel rounds up or
down. When I do individual rounds it is out. Can you assist with how to get
the two sheets to correspond. I was not able to round the total amount from
the cash flow, if this works please provide formula.