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" wrote in message
ink.net...
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