excel formula to enter "0" if cell blank

[Curt]

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

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

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


"Curt" <[email protected]> wrote in message
news:[email protected]...
> trying to eliminate error messages needed for math formula. With "0" in
cells
> works good "anyone"

[sajay]

ask me



sajay

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

"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" <[email protected]> wrote in message
> news:[email protected]...
> > trying to eliminate error messages needed for math formula. With "0" in
> cells
> > works good "anyone"
>
>
>

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

"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" <[email protected]> wrote in message
> news:[email protected]...
> > trying to eliminate error messages needed for math formula. With "0" in
> cells
> > works good "anyone"
>
>
>

[Curt]

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

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

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

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

"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" <[email protected]> wrote in message
> news:[email protected]...
> > trying to eliminate error messages needed for math formula. With "0" in
> cells
> > works good "anyone"
>
>
>

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