Forum Discussion
Excel formula not working in some cells
The simple formula that I have written is not calculating properly in certain cells. This has been happening in spreadsheets that I have been creating for about a week. Here is a simple example of...
Baja2020 That's the correct result - 10/120000 = 0.0000833 = 8.33*10^-5. It's just showing in scientific notation as it's very small.
By the way, your column header says these are percentages, but they aren't - try changing to percentage format from the Home Ribbon.
