Excel公式中的参数过多 [英] Excel formula has too many arguments

问题描述

我创建了以下公式来运行一系列以文本格式保存的客户编号.

I created the below formula to run of a series of customer numbers saved in text format.

=IFERROR(IF(AND((LEFT($J3,3)="028"),$N3=11),"NI Landline",IF(AND((LEFT($J3,2)="07"),$N3=11),"Mobile","Other Number")),"Other Number")

故障:

=IFERROR(
    IF(AND((LEFT($J3,3)="028"),$N3=11),
        "NI Landline",
    IF(AND((LEFT($J3,2)="07"),$N3=11),
        "Mobile",
    "Other Number")),
"Other Number")

此公式可以正常工作，但我需要对其稍加修改以进一步区分数字，因此我将其修改为以下内容:

This formula works fine but I needed to amend it slightly to differentiate the numbers a bit further, so I amended it to the below:

=IFERROR(IF(AND((LEFT($J2,3)="028"),$N2=11),"NI Landline",IF(AND((LEFT($J2,2)="07"),$N2=11),"UK Mobile",IF(AND((LEFT($J2,5)="00353"),$N2=14),"ROI Number","Other Number")),"Other Number")

故障:

=IFERROR(
    IF(AND((LEFT($J2,3)="028"),$N2=11),
        "NI Landline",
    IF(AND((LEFT($J2,2)="07"),$N2=11),
        "UK Mobile",
    IF(AND((LEFT($J2,5)="00353"),$N2=14),
        "ROI Number",
    "Other Number")),
="Other Number")

考虑到我已经复制了第一个"IF"部分中的条件，因此我运行了该公式，并返回了太多参数".我删除了新部分，使其与第一个公式相同，并且工作正常.我检查了括号，但数字在两侧都匹配.有什么想法吗?

Thinking I've replicated the conditions from the first 'IF' sections, I ran the formula and it returned 'too many arguments'. I've removed the new section so that it is the same as the first formula, and it works fine. I've checked the parentheses but the number matches on both sides. Any ideas?

我希望这是愚蠢的，任何帮助将不胜感激！ 谢谢 利亚姆

I'm hoping it is something stupid, any assistance would be greatly appreciated! Thanks Liam

推荐答案

您似乎在and()语句的早期关闭了括号:请尝试在028和07"和353之后删除右括号

you seem to be closing the brackets early for the and() statements : try removing the close brackets after 028" and 07" and 353"

前两个代码也是如此:

IF(AND(LEFT($J2,3)="028",$N2=11),"NI Landline",IF(AND((LEFT($J2,2)="07"),$N2=11),"UK Mobile","check"))

您应该可以从这里展开.

You should be able to expand from here.

显示示例的图像:

这篇关于Excel公式中的参数过多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！