Better for general use, IF or CASE?

[JP Romano]

Hi... I'm about to embark on a new project here at work, and as I understand it from the cocktail napkin requirements, I'm going to be doing a lot of calculations based on user input to a form I'll set up. I've been reading a bit about using CASE statements. I'm already pretty comfortable with using multiple IF's using global variables and am wondering if CASE statements are a better choice. Seems like they basically do the same thing... am I missing something?

Thanks for your valued input, as always!

[shg]

You would think that If/ElseIf/EndIf and Case statements would generate the same code, but I've heard that the former is more efficient.

Even so, I'd opt for Case statement for readability. Arrange the cases from most likely to least likely if possible (equally true for If/ElseIf/EndIf).