I have a spreadsheet of data, and the results returned are slightly different to when I manually add it up on a calculator and its driving me mad.
The formula is =+A2*D2/100
A2 is typically a large figure such as 55000 and D2 is always a decimal such as 1.5.
I cannot get the same figure when i enter the same equation on a calculator. Any ideas why?
the column the ouput of this equation is in is formatted accounting with 2 decimal places. A2 is formatted custom, and column d is formatted number