If cell value equals zero

Hello,

I have a simple worksheet formula, "=IF(D17=0,"",(D11*1.38+D14)/D17)"
located in D22.
This works fine if D11 has a value in it, but there are a few instances
where D11 is blank, then I get "#VALUE" in D22.
How can I modify the formula to increment D11 to "1" if it is blank or equal
to "0"?

Thanks...

---
Steve

Hi!

>increment D11 to "1" if it is blank

If you're getting #VALUE! when D11 is "blank", it must be a formula blank.

Onr way:

=IF(D17=0,"",(IF(OR(D11={"",0}),1,D11)*1.38+D14)/D17)

Biff

"Steve" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I have a simple worksheet formula, "=IF(D17=0,"",(D11*1.38+D14)/D17)"
> located in D22.
> This works fine if D11 has a value in it, but there are a few instances
> where D11 is blank, then I get "#VALUE" in D22.
> How can I modify the formula to increment D11 to "1" if it is blank or
> equal to "0"?
>
> Thanks...
>
> ---
> Steve
>

See if this works for you:

D22: =IF(D17=0,"",(IF(N(D11)=0,1,D11)*1.38+D14)/D17)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Steve" wrote:

> Hello,
>
> I have a simple worksheet formula, "=IF(D17=0,"",(D11*1.38+D14)/D17)"
> located in D22.
> This works fine if D11 has a value in it, but there are a few instances
> where D11 is blank, then I get "#VALUE" in D22.
> How can I modify the formula to increment D11 to "1" if it is blank or equal
> to "0"?
>
> Thanks...
>
> ---
> Steve
>
>
>