SUM formulas with exceptions

[asmith1946]

I'm trying to write a formula that will add "500" to the adjacent cell quantity, like this =IF(D3:D100>0,D3:D100+500,"") It's working but I'm getting an error. Please help!

 

[asmith1946]

i should add, if the C1 is blank I want D1 to stay blank as well. So I used a "IF" formula, is there a better way to write this?

 

[Aladin Akyurek]

In E3 enter and copy down:

=IF(ISNUMBER(1/D3),D3+500,"")

 

[asmith1946]

thanks! that is working but it still comes back with an error

 

[Aladin Akyurek]

thanks! that is working but it still comes back with an error

What is the error you get and what is the value of D3 when you get that error?