Message: Too many arguments for this function.

Question

When entering the following formula as a Conditional Formatting rule:

=len(trim($X$28,$AD$28,$X$30))=0

I get the following message: "You've entered too many arguments for this function.  To get help with this function, click OK to close this message.  Then click the Insert Function button located to the left of the equal sign in your formula."

I closed the message, but there is no "Insert Function" button visible.

How do I resolve this where CF will accept the formula?

Note: This is a continuation of a post onTuesday, December 07, 2010 2:30 PM, "Quote mark pair differences in conditional formatting” that remains open and not marked as answered.

Answer 1

Phil Hageman wrote:

When entering the following formula as a Conditional Formatting rule:

=len(trim($X$28,$AD$28,$X$30))=0

I get the following message: "You've entered too many arguments for this function. [....]"

I suspect you want:

=len(trim($X$28 & $AD$28 & $X$30))=0

If not, explain in English what you are trying to accomplish.  That is, "test <what?> for a length of zero".