show 0.00 if referenced cell is empty
 

this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

show 0.00 if referenced cell is empty
 

On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln

show 0.00 if referenced cell is empty
 

=IF(B9="",0,2240/(B9*7.2))
__________________________________________________ _____________________

"David D" wrote in message
...
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

show 0.00 if referenced cell is empty
 

Try this:

=IF(B9="",0,2240/(B9*7.2))

HTH,
Elkar


"David D" wrote:

this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

show 0.00 if referenced cell is empty
 

That works great until I try to use it in a cell that adds 2 cell together;

Cell B9= empty or blank cell
Cell B10= no error msg. where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)


Cell B22= =SUM(B9,B16)
Cell B23= #DIV/0! where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)


"Mark Lincoln" wrote in message
oups.com...
On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln

show 0.00 if referenced cell is empty
 

Cell B23 in your second example should produce exactly the same result
as cell B10 in the first example; it's the same formula. Should it
have referred to cell B22?

Regardless, I didn't test for zero in my original reply. Here's an
amended formula:

=IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0)

This sets the result to zero unless cell B9 is both numeric and
nonzero. Sorry for the trouble.

Mark Lincoln

On Jun 26, 3:47 pm, "David D" wrote:
That works great until I try to use it in a cell that adds 2 cell together;

Cell B9= empty or blank cell
Cell B10= no error msg. where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Cell B22= =SUM(B9,B16)
Cell B23= #DIV/0! where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

"Mark Lincoln" wrote in message

oups.com...



On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln- Hide quoted text -

- Show quoted text -

show 0.00 if referenced cell is empty
 

Mark, Thanks that worked fine...

David

"Mark Lincoln" wrote in message
ps.com...
Cell B23 in your second example should produce exactly the same result
as cell B10 in the first example; it's the same formula. Should it
have referred to cell B22?

Regardless, I didn't test for zero in my original reply. Here's an
amended formula:

=IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0)

This sets the result to zero unless cell B9 is both numeric and
nonzero. Sorry for the trouble.

Mark Lincoln

On Jun 26, 3:47 pm, "David D" wrote:
That works great until I try to use it in a cell that adds 2 cell
together;

Cell B9= empty or blank cell
Cell B10= no error msg. where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Cell B22= =SUM(B9,B16)
Cell B23= #DIV/0! where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

"Mark Lincoln" wrote in message

oups.com...



On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is
entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln- Hide quoted text -

- Show quoted text -

show 0.00 if referenced cell is empty
 

shorter version

=IF(B9,2240/(B9*7.2),0)


"Mark Lincoln" wrote:

Cell B23 in your second example should produce exactly the same result
as cell B10 in the first example; it's the same formula. Should it
have referred to cell B22?

Regardless, I didn't test for zero in my original reply. Here's an
amended formula:

=IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0)

This sets the result to zero unless cell B9 is both numeric and
nonzero. Sorry for the trouble.

Mark Lincoln

On Jun 26, 3:47 pm, "David D" wrote:
That works great until I try to use it in a cell that adds 2 cell together;

Cell B9= empty or blank cell
Cell B10= no error msg. where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Cell B22= =SUM(B9,B16)
Cell B23= #DIV/0! where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

"Mark Lincoln" wrote in message

oups.com...



On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln- Hide quoted text -

- Show quoted text -

show 0.00 if referenced cell is empty
 

That works as long as B9 is blank or a number, but produces a #VALUE!
error if B9 is nonnumeric, i.e., text.

I would rather most of my users see a zero result as opposed to the
error message--they don't panic nearly as badly. ;)

Mark Lincoln

On Jun 26, 11:22 pm, Teethless mama
wrote:
shorter version

=IF(B9,2240/(B9*7.2),0)



"Mark Lincoln" wrote:
Cell B23 in your second example should produce exactly the same result
as cell B10 in the first example; it's the same formula. Should it
have referred to cell B22?

Regardless, I didn't test for zero in my original reply. Here's an
amended formula:

=IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0)

This sets the result to zero unless cell B9 is both numeric and
nonzero. Sorry for the trouble.

Mark Lincoln

On Jun 26, 3:47 pm, "David D" wrote:
That works great until I try to use it in a cell that adds 2 cell together;

Cell B9= empty or blank cell
Cell B10= no error msg. where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Cell B22= =SUM(B9,B16)
Cell B23= #DIV/0! where I have the formula,
=IF(ISNUMBER(B9),2240/(B9*7.2),0)

"Mark Lincoln" wrote in message

roups.com...

On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -