using multiple and/or in an if

[russc2541]

Small part of a macro I'm working on: trying to select if a value is within certain criteria.

values will be blank or a number. OK numbers are 1-122, 205-211, 216-222, 305-311, 312-322, 401-424.

can I stack a bunch of or __ and__ arguements like this

Please Login or Register  to view this content.

or does each need to be a nested if like

Please Login or Register  to view this content.

(I know this isn't right or finished, just a quick thrown together example)

Or is there a different/better way to do it?

[Solus Rankin]

Please Login or Register  to view this content.

Maybe?

[russc2541]

yes, that works well. Here's what I ended up with:

Please Login or Register  to view this content.

Also switching another messy if to something like this elsewhere in the macro.

Thanks