Formula Structure for Performance


how to create best formula for using IF ELSE?

Best Answers

  • ArunManickam

    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> this way you get faster performance (lets say you are expecting 0 on more than 50% of the cells)...