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?
View best response
Either the column width is too small to show the decimals or the number format prevents showing the decimals.
It is still not working. It keeps on giving me 0
Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
Thank you. Just fixed it.