i want to add to formula t

in column c1 there is a formula

=a1/b1 (let say formula is: x)

but x gives error (division by zero) in some cells

i want to add

=IF(ISERROR(FORMULA A);"N.M.";(FORMULA A))

is this possible

it will be too difficult maybe impossible for me to write every cel
different formulas
(the formula not the same in that whole worksheet

--
barkin
-----------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...fo&userid=2039
View this thread: http://www.excelforum.com/showthread.php?threadid=49269