How to optimize complex excel formula ? RRS feed

  • Question

  • Hi,

    How to optimize below mentioned complex formula to increase the speed of formula result. This formula is referred in one particular column for many rows. Only relative cell reference will be changed in this formula in different rows. Currently I planned to replace the in-build "AND" & "OR" Function with UDF (User-defined function) "ANDVBA" & "ORVBA" because In-build "AND" function will evaluate all conditions even though first condition is failed and in-build "OR" function will evaluate all conditions even though first condition is satisfied so in-build function OR & AND took more time.

    Pls suggest me how I can optimize this formula more efficiently further?


    Wednesday, May 4, 2016 5:25 PM