Formula Structure for Performance

how to create best formula for using IF ELSE?

Best Answers

  • my 10 cents here..say you calculate something based on a condition and 0 otherwise, you could structure it like 

    if not <condition> then 0 else <calculation>..by this way you get faster performance (lets say you are expecting 0 on more than 50% of the cells)...

Answers