Blanks in Formula Treated as Zero's

[LutonBarry]

Folks,

I'm struggling here I have a sheet to measure on a daily basis the in and outs of a process.

The formula I have is '=IF(SUM(B3+C3>0),0,-2). So logically if there's be either a qty in or a qty out, doesn't have to be both the returned value should be 0. If there are no in and outs then a zero is returned.
The formula works fine until I have blank cells for the days in the week to follow, these cells are treated as zero's which skews the numbers. I would like those cells treated as empty unless containing a number.

[mikerickson]

What do you mean "treated as empty"

If both cells are empty, what result do you want?

[LutonBarry]

Mike Basically I'd like the 0 if blank or empty, currently it returns -2.

Thanks for looking Mike.

[SamT]

Sum(X+Y>Z) is bad syntax times 2
Try
=IF(B3+C3>0,0,-2)
OR
=IF(SUM(B3,C3)>0,0,-2)

[p45cal]

Guessing that C3 contains "the days in the week to follow",try:
=IF(C3="","",IF((B3+C3)>0,0,-2))

[LutonBarry]

Sam, Thanks the bottom formula is the kiddie. Looks so simple too should have started afresh.

[LutonBarry]

Sam, Thanks the bottom formula is the kiddie. Looks so simple too should have started afresh.

[mikerickson]

How about =IF(SUM(B3,C3)>=0,0,-2)

[LutonBarry]

Apologies all for your help. the formula that I thought worked that Sam supplied unfortunately didn't. but P45cal's has so many thanks for all of your time and help with this one.