'Different equation results from typing number and =cell address
I hope you can help. I am compiling a sheet that runs a set of equations at the end of the row. To make things easier, I am using data from another sheet to autopopulate my formula's. The problem I am finding is I get different results when using =cell address vs typing in the number directly. The number is 0.7 and is only to 1 decimal place. Even if I "ctrl C" the data into the cell, it produces the same answer as using the =.
It's left me a bit stumped as to why. Can anyone shed some light as to what is happening? Thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|