why does excel move up to the next point

February 18, 2014 at 02:40:14
Specs: Windows 7
When having excel do a sum if the sum for example finishes with .67 it will make it .68 or .66 sending the total up a point or down a point . but if I put the figure in manually it adds the right total , even though I have set to 2 places in the format MENU

See More: why does excel move up to the next point

Report •

February 18, 2014 at 03:58:05
Excel stores the exact number in its memory and will round that number up or down based on how manner digits you choose to display.

Please give us an example of the numbers you are using that causes this to happen.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question