Is there a limit to the number of formulas in an Excel worksheet?

D

Del

Is there a limit to the number of formulas in an Excel worksheet? When I do a
function check on my formula, the function box shows the correct answer, so I
know my formula is correct. Currently I have about 250 correctly displayed
formulas on this one sheet, but I need to add 36 more.
 
F

Fred Smith

Excel will easily handle 286 formulas. It will handle multi-thousands,
dependent only on memory.

Regards,
Fred.
 
J

JP

On one spreadsheet I had about 2,000 very large array formulas, so you
should be safe <g>.

--JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Display weeks from a Milestone 0
Calculate the median value before a specified list 0
Maximum number of cells for 'SUM' ? 7
formula displays as a formula, not as its result 1
Editing an "IF" function across a worksheet/excel file 2
Excel Formula question 0
Using lookup functions for Order Sheet 1

Top