Apr 09 2020 03:22 AM
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 where cell D3 comes up with a faulty result.
Apr 09 2020 03:28 AM
@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.
Apr 09 2020 03:43 AM
Thanks Savia. If I use the percentage format won't it just show up as )? @Savia
Apr 09 2020 04:22 AM
@Baja2020 I can't see why it would. Percentage format just multiplies the apparent value of the cell by 100 and sticks a % on the end.