Creating customized function with many conditions

Hi Guys,

Please help me on the user defined function i have created in VBA considering many conditions.

Below are the conditions.

STEP QTY LOT STATUS Result
SORT1 or SORT2 = 0 or blank PREQ OK
SORT1 > 0 PREQ Move to Sort1 POSTQ
SORT1 > 0 POSTQ Move to Sort2 PREQ
SORT2 > 0 PREQ Move to Sort2 POSTQ
SORT2 > 0 POSTQ Move to DI


I tried creating below function however, when I tried to run it with different conditions, I am only getting one result which is "Move to Sort1 POSTQ"

Please Login or Register  to view this content.

Appreciate the feedback.
Thanking everyone in advance.

Note : instead of & use AND for your conditions.

Ok, try this then.

Please Login or Register  to view this content.

note that you should always use "Option Explicit" and declare your variables to avoid problems...