Tag Archives: Functions and Formulas

No Thumbnail

Excel Speed, IF (Formula vs VBA)

I have conducted several tests to see the fastest way to implement an If function in Excel. In these tests I have compared the native excel IF() function, with several methods of using the “if” statement in VBA. Each test basically executes the following algorithm