Formula Fields
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 #] =...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is the formula for Providing Agency
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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
------------------------------
Getting error related to "AND"
------------------------------
Del
------------------------------