P
peabrain25
I am working with an accounting worksheet and using the following formula:
=If(D12-D13 = 0, "Balanced", D12-D13)
D12 is a subtotal for all entries on the page and D13 is a total from
another cell. The problem I am having is that most of the time the function
works properly, and it will give me the "Balanced" answer that I am looking
for. However, when I change some of the numbers in the list (which changes
the subtotal) and I change D13 to match it, instead of getting "Balanced" I
get a difference of 0.00. If the difference is 0, then why is it not showing
"Balanced"? For example, 15.50+20.00 = 35.50 for a subtotal for D12. When I
put 35.50 in D13 it says "Balanced". However, when I put $57.96+4237.99 =
4295.95, but when I put 4295.95 in D13, I just get "0.00", the difference
between the two. There are no extra decimal points or spaces or anything like
that in any of the figures. Sorry to babble on and on, but has anyone else
encountered this before or have any suggestions? Thanks!
=If(D12-D13 = 0, "Balanced", D12-D13)
D12 is a subtotal for all entries on the page and D13 is a total from
another cell. The problem I am having is that most of the time the function
works properly, and it will give me the "Balanced" answer that I am looking
for. However, when I change some of the numbers in the list (which changes
the subtotal) and I change D13 to match it, instead of getting "Balanced" I
get a difference of 0.00. If the difference is 0, then why is it not showing
"Balanced"? For example, 15.50+20.00 = 35.50 for a subtotal for D12. When I
put 35.50 in D13 it says "Balanced". However, when I put $57.96+4237.99 =
4295.95, but when I put 4295.95 in D13, I just get "0.00", the difference
between the two. There are no extra decimal points or spaces or anything like
that in any of the figures. Sorry to babble on and on, but has anyone else
encountered this before or have any suggestions? Thanks!