The formula in the image below in cell D25 is=IF(B25,C25, 0), and the formula is copied to the other cells in that column. This means cells in the D column should take on the value in the C column (same row) if the B column cell for that row evaluates to TRUE (e.g. =1). Yet, this one"s evaluating to 1 instead of 0.5 as it should. Why?

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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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

Super User works best with JavaScript enabled

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.