Or statement tested first

[yawnzzzz]

I'm wondering if there's a way to have one part of an Or statement tested first.

For example, I have a statement that if it's not true, then the second part of my test will cause an error, so I need the first statement to always be tested before the second.

I could write this statement with a nested if, but my coding would look prettier with an Or. Any ideas?

[squiggler47]

Can you give an example of the data?

[yawnzzzz]

My example is pretty complex, so I'll make one up.

Please Login or Register  to view this content.

I'm going to want to evaluate divider = 0 first, so that if it does equal zero I don't attempt to divide a number by 0.

[squiggler47]

Its down to the IF, even with AND() it evaluates both halfs instead of failing after the first!

=10/(ISERROR(10/C11)+C11)=5

=IF(C11=0,FALSE,10/C11=5)

=10/(C14-(C14=0))=5

are other options

[davegugg]

Why not go:

Please Login or Register  to view this content.

[yawnzzzz]

Why not go:

Please Login or Register  to view this content.

That's what I currently have. It works correctly, but it makes the code a lot messier, and when you have over 100 pages of vb in one excel file, you tend to look for the simplest way.

[JBeaucaire]

Testing the divisor for zero first with an IF query IS the easiest way.

[davegugg]

Could you maybe go with a select case?

Please Login or Register  to view this content.

I don't know as much about Select Case, is it faster/neater?

[JBeaucaire]

The fastest is IF, get's the job done every time in the first step. Anything else is really just having fun with VBA.

[Cheeky Charlie]

but my coding would look prettier with an Or

You're in the wrong job

but seriously - it's not just unnecessary - it's harder to debug later - I know people who insist on using IF blocks for single option scenarios - like:
if a then
do b
end if

because it's easier to read

Making vba shorter does not make it better - commenting properly makes it better
!!

CC