Automatic formula calculation is on and I did a Calculate Now before taking this screenshot.
You are watching: What formula would produce the value in cell c25
Excel is automatically rounding to the width of the column.
To display "0.5" the column width must be greater than 3.
Pressing Increase Decimal won"t do a thing unless the column is wide enough, so the first step is to increase column width. Unless you"ve previously formatted the cell to round to integer values, that alone should solve it.
Thanks for contributing an answer to Super User!Please be sure to answer the question. Provide details and share your research!
But avoid …Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Post Your Answer Discard
Not the answer you're looking for? Browse other questions tagged microsoft-excel worksheet-function microsoft-excel-2013 or ask your own question.
Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard
How to update excel formula and propagate the change to other cells (alternative to cell dragging after formula change)
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.11.8.40681
See more: How To Get Fabric Paint Out Of Clothes And More, How To Remove Fabric Paint From Clothing