Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Which is quicker?

Which of these is quicker ?

"Iif" (inline if) or "If.. then... End If" ???
Speed is cruicial in the routine I need them in...
0
lbowers
Asked:
lbowers
1 Solution
 
KJHDI12Commented:
I did some calculations and ran them in 1000000 loops and got this result:

  If then else end if:        1492ms
  Iif                         9500ms

I used the ARTimer control to time it. It's free and you can download it at www.download.com.

Mr. Fixit

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now