num!

[pierre]

hi
i have :

A
1 10
2 #num!
3 #num!

how to compose the formula in cell B1 :
if A1 is NOT an error give me its value 10 ...and if false... 20

 

[Tim879]

=IF(ISERROR(A1),20,A1)

use this formula and put it in another cell in the workbook.

if you want "20" to appear in cell a1, then you need to replace the
"a1" in the formula above with the formula that is generating the
error (i.e. =IF(ISERROR(A1/B1),20,A1/B1)