Increasing Arguments

C

Cathy

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
 
B

Bob Phillips

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)
 
N

Niek Otten

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
 
Top