Cowlers
12-05-2011, 09:48 AM
Hi All,
I have a strange situation in Excel and I cannot see where I'm going wrong.
I have attached an image showing the way my formulae are set up. You can see this is a simple arithmetic function and I'd expect the following to be the case:
7034
Cell F13 would calculate the sum of G13:I13, i.e. 5.21 + 363.02 + 0 = 368.23
Cell D13 would find the sum of E13:F13 i.e. 0 + 368.23 and delete this value from the value of C13, i.e. 368.23 - 368.23 = 0
I would therefore expect cells D13 to equal "" as opposed the "****" value that has resulted from this calculation.
If I evaluate the formula I see that apparently 368.23 - 368.23 does not equal 0 as I was taught but in fact it equals a tiny exponential amount which seems to be where my problem lies!
Please could someone help me to overcome this?!
Thanks for your time in advance,
Dan
I have a strange situation in Excel and I cannot see where I'm going wrong.
I have attached an image showing the way my formulae are set up. You can see this is a simple arithmetic function and I'd expect the following to be the case:
7034
Cell F13 would calculate the sum of G13:I13, i.e. 5.21 + 363.02 + 0 = 368.23
Cell D13 would find the sum of E13:F13 i.e. 0 + 368.23 and delete this value from the value of C13, i.e. 368.23 - 368.23 = 0
I would therefore expect cells D13 to equal "" as opposed the "****" value that has resulted from this calculation.
If I evaluate the formula I see that apparently 368.23 - 368.23 does not equal 0 as I was taught but in fact it equals a tiny exponential amount which seems to be where my problem lies!
Please could someone help me to overcome this?!
Thanks for your time in advance,
Dan