The first portion of the IF statement (logical_test) returns "Uni" (value_if_true) for certain item number, description, or location. And the rest (value_if_false) will return "mammo" if the item number is "MDT~", otherwise it returns "patient".
I thought I can add a string in the (value_if_false) that will return "patient-janitorial" if the item number starts with "D", but I wasn't successful.
Please let me know if there are any other info needed. Thank you for your help!
|