If cell value equals zero

S

Steve

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

Biff

Hi!
increment D11 to "1" if it is blank
Click to expand...

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
 
R

Ron Coderre

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
 
Top