Comment Comment by dspillett MS Excel tries to be clever and disguise the most common places this is noticed.Give it =0.1+0.2-0.3 and it will see what you are trying to do and return 0.Give it anything slightly more complicated such as =(0.1+0.2-0.3) and this won't trip, in this example displaying 5.55112E-17 or similar. parent dspillett 7 years ago
Give it =0.1+0.2-0.3 and it will see what you are trying to do and return 0.
Give it anything slightly more complicated such as =(0.1+0.2-0.3) and this won't trip, in this example displaying 5.55112E-17 or similar.