How to automatically change the value of undefined to 0?

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

Hi,

If(iserror(your formula),"0",Your formula)

e.g.

=IF(ISERROR(B1/A1),0,(B1/A1)*1000)

Ed

wow cool!

thanks a lot ed!

No Problem.

Thanks for the feedback

Ed

Hi,
Can you please help me out on how to deal with this formula on my excel.
I want the cell that has (0.0/0.0)*100 to return 'o' and 3.4/0.0 to return 'undefine' in a long string of column.
Please, kindly help me out on how to write the formula. It is very urgent.
Thanks