View Single Post
 
Old 03-16-2016, 11:24 AM
nowco nowco is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2016
Posts: 3
nowco is on a distinguished road
Default

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!
Reply With Quote