Excel bug

Davidns

Board Regular
Joined
May 20, 2011
Messages
127
Office Version
  1. 365
Platform
  1. Windows
I have a spreadsheet wherein two cells that use the same formula are returning different results. Furthermore, when I then subtract the two cells from each other, the result is zero! To make matters worse, when I change the precedent cells, sometimes the two cells show the same results, and for other precedent values they don't.

When I see things like this, I get very worried about the integrity of Excel results. If anyone can shed light on what might be going on, perhaps i can sleep better tonight!

Thanks - happy to send more data if need be.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,835
Office Version
  1. 365
Platform
  1. Windows
Can you post the formula and some sample data?
 

Davidns

Board Regular
Joined
May 20, 2011
Messages
127
Office Version
  1. 365
Platform
  1. Windows
i think the best way would be to send the entire spreadsheet. Would that be ok to send (not that familiar with this site)? Or should I send to you directly? Thanks, David
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,835
Office Version
  1. 365
Platform
  1. Windows
David

There's no option to upload here, but you could upload to a file-sharing site like Box.net and post a link here.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
Does Circular References appear at the bottom left of the window, next to Ready?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,550
Messages
5,529,472
Members
409,884
Latest member
Msinmath
Top