useing edit to try to get it to input "0" where needed. goto & edit both say
no cells found to match leaving find what 'empty'
tried " " did not take.

"Max" wrote:

Maybe something along the lines of:

=if(B1="",0, <formula)

=IF(OR(A1="",B1=""),0,<formula)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Curt" wrote in message
...
trying to eliminate error messages needed for math formula. With "0" in
cells
works good "anyone"