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屋！