Didn't explain well enough. trying to create a macro that will update. Input
0's where needed. Formula looks for a value and gives error if cell blank.

"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"