excel formula to enter "0" if cell blank

[Guest]

trying to eliminate error messages needed for math formula. With "0" in cells
works good "anyone"

 

[Max]

Maybe something along the lines of:

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

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

 

[Bob Phillips]

What is the formula that gives the error, it seems best to address that.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[sajay]

ask me



sajay

 

[Guest]

the formula is looking for a value that is missing. The value can become
missing by operator error. Trying to create a update macro that will input
0's where needed.

 

[Guest]

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.

 

[Guest]

Trying to create a macro that will input 0"s where needed. Formula looks for
a value and returns error.

 

[Guest]

When useing edit & goto get message no cells found for blanks. no data in
worksheet Does excel 2000 not accept find what empty. what should be entered
for a blank cell?

 

[Guest]

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]

Curt, think Dave Peterson has provided a much better handle on your query
for a macro, which I noted you had since pursued in a subsequent post.
I've got nothing further to offer you. cheers.