LutonBarry
10-26-2016, 06:30 AM
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.
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.