Forum Discussion
Solved
Very simple Division question
I'm not sure why this is not working. I'm trying to divide a cell (8) by a certain number (20) and it gives me the answer "0" because the answer would be a decimal. Is there anyway to fix that?
Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
Either the column width is too small to show the decimals or the number format prevents showing the decimals.
- If you use QUOTIENT like this:
=QUOTIENT(8,20)
the formula returns 0 because QUOTIENT returns only the integer portion and truncates the decimal portion.
You may need to simply use this formula:
=8/20
to return 0.4 as you expected.Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
