Quote:
Originally Posted by ExistenceNow
Interesting, though not really an issue for my purposes. I'm just trying to be lazy and not have to add two numbers together every day.
|
Yeah, I hear you. Based on your initial post, it sounds like you have a very simple worksheet setup. The thing with an IF statement is that it contains a logical operator, which takes up more calculation time. Using a strict SUM statement, eliminates the logical operation (IF this, then "do that", else "do something else"). You can have the zeroes not show using conditional formatting, which doesn't drain the processors when calculating a worksheet or workbook.