My wife and I have a spreadsheet to work out our finances at the beginning of each month and this month has a strange figure in cell
The formula in cell
="+ £"&-'Sue''s Outgoings'!C13&" Shortfall" which should output
+ £57.35 Shortfall but it outputs
+ £57.3500000000001 Shortfall.
To try and troubleshoot this, I put
=-'Sue''s Outgoings'!C13 in cell
F13 which outputs exactly what is in
'Sue''s Outgoings'!C13 which is 57.35. (see second image below)
All cells in
Sue's Outgoings sheet are formatted to
Currency format and I temporarily reformatted all cells to
General to see if there was a hidden strange figure in there and there was nothing. All figures in
Sue's Outgoings sheet are straight figures and not results of formulae.
What other reason could there be for the spurious addition of 0.0000000000001 to the result?