Quote:
Originally Posted by rconverse
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.
|
What would that formula look like?