Forum Discussion
Solved
Division formula returns 0 value
I'm trying to use a simple formula to divide the value of one cell by the value in another cell and every time the result of the formula is "0". The two cells I'm using both have actual numbers in t...
The chances are that the format of the formula cells is set to show zero decimal places and if you copy the formula cell and paste it as a value you will get the actual underlying value or use a formula =VALUE(<reference to the formula cell>) and it will return the actual value. To deal with this scenario, increase the decimal places to do so custom format the formula cells as Numbers and increase the decimal places.
Wow that was it!!! Thank you so much. I was going crazy trying to figure that out. You're a life saver!
You're welcome iwarda! Glad I could help.