Formula Fields

Question

I am in need of a formula with a few conditions. See criteria below
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------------------------------

MarkShnierYou · Answer

Here is the formula for Providing Agency

IF(
[Service Type Authorization Description] = "Agency Hired", "Airplane Services",
[Service Type Authorization Description] = "Flight 10" AND [Responsible Payer] = "Paid", "Jetplace Services",
[Service Type Authorization Description] = "Flight 11" AND [Responsible Payer] = "Paid", "Jetplace Services")

Post back if you have any problem with the other three formula fields.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community