Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
it should put out R and S will display as RX and O and P as OTC.
What I I missing?
if(Dual(RxOtcInd = 'R','S', 'RX') ,(RxOtcInd= 'O','P', 'OTC'))
May be this:
If(Match(RxOtcInd, 'R', 'S'), 'RX',
If(Match(RxOtcInd, 'O', 'P'), 'OTC'))
May be this:
If(Match(RxOtcInd, 'R', 'S'), 'RX',
If(Match(RxOtcInd, 'O', 'P'), 'OTC'))