I am working with a formula where I need to use If and AND to look at two values in order to make a decision on the value. My formula looks like this:

if ({Orders.TargetDrugName} = "capecitabine") & ({Orders.Strength} = "150") then 287.99 else
if ({Orders.TargetDrugName} = "capecitabine") & ({Orders.Strength} = "500") then 1633.17 else
if {Orders.TargetDrugName} = "chlorambucil" then "952.82" else
if ({Orders.TargetDrugName} = "cyclophosphamide") & ({Orders.Strength} = "50") then 1718.11 else
if ({Orders.TargetDrugName} = "cyclophosphamide") & ({Orders.Strength} = "25") then 976.20 else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "100") then "No Cost Available" else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "140") then "No Cost Available" else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "20") then "No Cost Available" else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "50") then "No Cost Available" else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "70") then "No Cost Available" else
if ({Orders.TargetDrugName} = "dasatinib") & ({Orders.Strength} = "80") then "No Cost Available" else
if ({Orders.TargetDrugName} = "erlotinib hcl") & ({Orders.Strength} = "100") then 6213.88 else
if ({Orders.TargetDrugName} = "erlotinib hcl") & ({Orders.Strength} = "150") then 7028.34 else
if ({Orders.TargetDrugName} = "erlotinib hcl") & ({Orders.Strength} = "25") then 2281.12 else
if {Orders.TargetDrugName} = "everolimus" then 11151.95 else
if {Orders.TargetDrugName} = "hydroxyurea" then "No Cost Available" else
if ({Orders.TargetDrugName} = "imatinib mesylate") & ({Orders.Strength} = "400") then 9905.81 else
if ({Orders.TargetDrugName} = "imatinib mesylate") & ({Orders.Strength} = "100") then 8247.09 else
if {Orders.TargetDrugName} = "lapatinib ditosylate" then 5798.98 else
if {Orders.TargetDrugName} = "lenalidomide" then "No Cost Available" else
if {Orders.TargetDrugName} = "methotrexate sodium" then "No Cost Available" else
if ({Orders.TargetDrugName} = "nilotinib hcl") & ({Orders.Strength} = "150") then 9820.60 else
if ({Orders.TargetDrugName} = "nilotinib hcl") & ({Orders.Strength} = "200") then 9820.60 else
if ({Orders.TargetDrugName} = "sorafenib tosylate") & ({Orders.Strength} = "200") then 13755.12 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "100") then 717.26 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "140") then 1004.70 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "180") then 1291.75 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "20") then 143.53 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "250") then 640.75 else
if ({Orders.TargetDrugName} = "temozolomide") & ({Orders.Strength} = "5") then 35.88 else
if {Orders.TargetDrugName} = "thalidomide" then "No Cost Available";

In this formula, Crystal says I need a number in place of the last "if". I know I'm doing something wrong, but troubleshooting is proving to be a headache.

Thanks

Jeff