if statement

[#1]

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'))

[sunny_talwar · Accepted solution]

May be this:

If(Match(RxOtcInd, 'R', 'S'), 'RX',

     If(Match(RxOtcInd, 'O', 'P'), 'OTC'))