我遇到了“您為此函數輸入了太多參數”錯誤,並且無法弄清楚原因。我已經為我需要的必要場景提供了嵌套的 IF 語句和 AND 語句。但我一生都無法弄清楚我錯過了什麼。有人嗎?
=IF(
HOUSING_PROVIDED = "Yes",
0,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "No",
PRIOR_EXCESS_HOUSING <= 0
),
0,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "No",
PRIOR_EXCESS_HOUSING > 0
),
PRIOR_EXCESS_HOUSING,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "No",
EXCESS_HOUSING = "Yes"
),
EXCESS_HOUSING,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "No",
EXCESS_HOUSING = "No",
HOUSING_RENTAL_LIMIT > 0
),
HOUSING_RENTAL_LIMIT,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "No",
EXCESS_HOUSING = "No",
HOUSING_RENTAL_LIMIT <= 0
),
"Run Data Calc",
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY <> "Core",
EXCESS_HOUSING = "Yes"
),
EXCESS_HOUSING,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY <> "Core",
EXCESS_HOUSING = "Yes"
),
HOUSING_RENTAL_LIMIT > 0,
HOUSING_RENTAL_LIMIT,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY <> "Core",
EXCESS_HOUSING = "Yes"
),
HOUSING_RENTAL_LIMIT <= 0,
"Run Data Calc",
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY = "Core",
DUAL_CAREER_LOWER_YN = "Yes"
),
0,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY = "Core",
DUAL_CAREER_LOWER_YN = "No",
EXCESS_HOUSING = "Yes"
),
EXCESS_HOUSING,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY = "Core",
DUAL_CAREER_LOWER_YN = "No",
HOUSING_RENTAL_LIMIT > 0
),
HOUSING_RENTAL_LIMIT,
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY = "Core",
DUAL_CAREER_LOWER_YN = "No",
HOUSING_RENTAL_LIMIT <= 0
),
"Run Data Calc",
"Dont Run Data Calc"
)
)
)
)
)
)
)
)
)
)
)
)
)
答案1
如果我沒看錯的話,下面的IF()
呼叫有 4 個參數:
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY <> "Core",
EXCESS_HOUSING = "Yes"
),
HOUSING_RENTAL_LIMIT > 0,
HOUSING_RENTAL_LIMIT,
IF(
...
)
)
它從擴充程式碼中的第 53 行開始。
還有另一個語句,從第 63 行開始,也有 4 個參數:
IF(
AND(
HOUSING_PROVIDED = "No",
HOUSING_RECALC_YN = "Yes",
DUAL_CAREER_YN = "Yes",
SPOUSE_POLICY <> "Core",
EXCESS_HOUSING = "Yes"
),
HOUSING_RENTAL_LIMIT <= 0,
"Run Data Calc",
IF(
...
)
)
但說真的,夥計,不要這樣做。從後天開始,你將永遠無法修改它。很簡單,因為你將無法理解你為什麼這樣做、如何做、甚至是做什麼。 ;)