Forum Discussion

Baja2020's avatar
Baja2020
Copper Contributor
Apr 09, 2020

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...
Formulas and Functions
Baja2020's avatar
Baja2020
Copper Contributor
Apr 09, 2020

Thanks Savia. If I use the percentage format won't it just show up as )? Savia 

Savia's avatar
Savia
Iron Contributor
Apr 09, 2020

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.

Resources