excel formula to enter "0" if cell blank
 

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

excel formula to enter "0" if cell blank
 

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"

excel formula to enter "0" if cell blank
 

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)


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

excel formula to enter "0" if cell blank
 

ask me



sajay

excel formula to enter "0" if cell blank
 

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.

"Bob Phillips" wrote:

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)


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

excel formula to enter "0" if cell blank
 

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"

excel formula to enter "0" if cell blank
 

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

"sajay" wrote:

ask me



sajay

excel formula to enter "0" if cell blank
 

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?

"Curt" wrote:

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

"sajay" wrote:

ask me



sajay

excel formula to enter "0" if cell blank
 

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"

excel formula to enter "0" if cell blank
 

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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--