Hi guys.

say i have 3 columns. the formula of my last column is 2nd column/1st column x 1000. (2nd column divided by 1st column times 1000) hence, if the value of my 1st column is 0, the 3rd column will be undefined. How do i make the value of the 3rd column be 0 if it happens to be undefined?

Thanks in advance!

Cheers,
Rukia