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)


"Cathy" wrote in message
...
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

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

"Cathy" wrote in message
...
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