How long Excel can handle functions?
 

Dear Excel Experts,

I have one quick question: how long can Excel (2003) handle
mathematical formulas or logical functions in one cell?

Thanks so much ... :rolleyes:


--
hendra
------------------------------------------------------------------------
hendra's Profile: http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=572941

How long Excel can handle functions?
 

A formula can be up to 1024 characters long.

Biff

"hendra" wrote in
message ...

Dear Excel Experts,

I have one quick question: how long can Excel (2003) handle
mathematical formulas or logical functions in one cell?

Thanks so much ... :rolleyes:


--
hendra
------------------------------------------------------------------------
hendra's Profile:
http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=572941

How long Excel can handle functions?
 

As measured in R1C1 reference style.

Biff wrote:

A formula can be up to 1024 characters long.

Biff

"hendra" wrote in
message ...

Dear Excel Experts,

I have one quick question: how long can Excel (2003) handle
mathematical formulas or logical functions in one cell?

Thanks so much ... :rolleyes:


--
hendra
------------------------------------------------------------------------
hendra's Profile:
http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=572941


--

Dave Peterson

How long Excel can handle functions?
 

Other limits may apply also, such as a maximum of 7 nested functions within a
formula in a cell.

Use Excel's Help and search for Specifications to find out more.

"Biff" wrote:

A formula can be up to 1024 characters long.

Biff

"hendra" wrote in
message ...

Dear Excel Experts,

I have one quick question: how long can Excel (2003) handle
mathematical formulas or logical functions in one cell?

Thanks so much ... :rolleyes:


--
hendra
------------------------------------------------------------------------
hendra's Profile:
http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=572941