Microsoft Excel Checkbook Register

In the following columns I have the following:

A1 = Trans. Type / Check No.
B1 = Date
C1 = Description of Transaction
D1 = Withdrawals (-)
E1 = Deposits (+)
F1 = Balance


I utilized the following formulas, which is giving me a penny off.

=F2-D3+E3
=SUM(F2-D3+E3)
=IF(ISBLANK(A3),"",(F2-D3+E3))

I even went through a few You Tube videos and followed everything step-by-step only to come up with a penny off.

I am sorry if this has been posted in before, but I cannot seem to get a straight answer from anyone on what to do to remedy this situation. Everyone have said it is either a Microsoft Excel issue dealing with rounding and/or me entering the data incorrectly. I have gone through several times to verify my entries and they are correct, but I am still off a penny. Any assistance would be gr

Originally Posted by Bernie Deitrick

=if(isblank(a3),"",round(f2,2)-round(d3,2)+round(e3,2))

Thank you much, I cannot wait to go home and try this out. If possible could you explain the formula to me ... I have never been good with Excel's formula and my classes never really covered them when I took them in college. Thank you.

Originally Posted by Bernie Deitrick

Round simply returns a number rounded to the indicated number of decimals.

Say you have a formula

=A1*1.06

and in A1 you have

12.08

The formula will return
12.8048
which, if you format the cell for 2 decimal places, will show as 12.80. So you expect 12.80 as the value, but unless you round it, Excel uses 12.8048
If you simply add two of those cells together (each with the same value), your new cell will show 25.61, not 25.60 as you would expect. But using the round function ensures that 12.80 is used, as you expect, and 25.60 is the actual result.

Thank you much, I am looking forward to trying this when I get home.

Thank you very much for this post, I have been without a computer for quite a while and will give this another try tonight ...