SUM formulas with exceptions

asmith1946

New Member
Joined
Aug 27, 2018
Messages
3
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!
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

asmith1946

New Member
Joined
Aug 27, 2018
Messages
3
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,503
Messages
5,529,248
Members
409,858
Latest member
mr20201
Top