software

How can I increase the number of arguments in a formula from the max of 30 to
32?

I am very new at this so please forgive me.

Regards Cathy

Do you mean in a built-in formula, or one from a UDF?

Either way, 30 arguments seems far too many to me, what exactly are you
trying to do, there may be a better way?

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Cathyquot; gt; wrote in message
...
gt; How can I increase the number of arguments in a formula from the max of 30
to
gt; 32?
gt;
gt; I am very new at this so please forgive me.
gt;
gt; Regards Cathy
Hi Cathy,

You can't. But often you can combine several arguments to one.
=SUM(A1, B1, C1) has three arguments.
=SUM((A1:C1) has one argument.
=SUM(A1,B2,C3) has three arguments
=SUM((A1,B2,C3)) has one argument

--
Kind regards,

Niek Otten

quot;Cathyquot; gt; wrote in message
...
gt; How can I increase the number of arguments in a formula from the max of 30
gt; to
gt; 32?
gt;
gt; I am very new at this so please forgive me.
gt;
gt; Regards Cathy