Formula Fields
I am in need of a formula with a few conditions. See criteria below
------------------------------
Del
------------------------------
If [Service Type Authorization Description] = 'Agency Hired', then [Providing Agency] = "Airplane Services", [Provider ID #] = 12345, [Provider Tax ID] = 5555, [NPA #] = 5555
If [Service Type Authorization Description] = 'Flight 10' OR 'Flight 11' AND [Responsible Payer] = 'Paid', then [Providing Agency] = 'Jetplace Services', [Provider ID #] = '6789', [Provider Tax ID] = 6666, [NPA #] = 6666
Formula Text Fields;
Providing Agency
Provider Id #
Provider Tax ID
NPA #
------------------------------
Del
------------------------------
