excel formula to enter "0" if cell blank

C

Curt

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

Max

Maybe something along the lines of:

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

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

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)
 
C

Curt

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.
 
C

Curt

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.
 
C

Curt

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

Curt

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?
 
C

Curt

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.
 
M

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.
 
Top