I’m having rounding issues using Google Spreadsheets, like 12.50% is 1250% in Module 2. Help, please.
ANSWER:
Google Spreadsheet decided that for your spreadsheet you wanted a percent as the final answer so it already multiplied by 100 for you. This happens sometimes and you can change the Format manually if it happens. So, if you are seeing something like the following:
| 1250% |
| 5000% |
| 1250% |
| 2500% |
the above is an image percentages over 1000%
One fix is to change the format of the number so that it is a “number” and not a percentage.
Here is a picture of me changing it in a Google Spreadsheet:
the above image shows me selecting FORMAT from the menu then going down to NUMBER
a menu to the right side appears and you select Number again (shown as 1,000.12).
Now it shows the values as numbers and you did it finding the percent yourself.
So, instead of 5000% you should have 50.00 or 50.00% .