Forum Discussion

Gnacc1997

Copper Contributor

Jul 17, 2019

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?

Division

SergeiBaklan
Jul 17, 2019
Gnacc1997

Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).

Detlef_Lewin

Silver Contributor

Jul 17, 2019

Gnacc1997

Either the column width is too small to show the decimals or the number format prevents showing the decimals.

Gnacc1997
Copper Contributor
Jul 17, 2019
Detlef_Lewin
- Twifoo
  Silver Contributor
  Jul 17, 2019
  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.
  - Gnacc1997
    Copper Contributor
    Jul 17, 2019
    Twifoo
    
    It is still not working. It keeps on giving me 0