Excel formula length

D

Dave

Hello,

I would like to create a formula in Excel 2K that is
longer than 255 characters but I get an error when I
attempt to do this.

How can I get around this?

Thanks.
 
I

ivano

How can I get around this?in formula you can use a definite name.
Es if you have in formula two time SUM(a1:a13) you can sostitute this whith
define name.
 
B

Bernard V Liengme

Dave,
Show us the formula so we can make relevant suggestions.
Bernard
 

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

Macro warning in word 1
Excell Otpions in office environment 0
Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Need Help with Macro Security 1
Outlook 365 overriding formatting choices 0
Adding recognised Zeros 5
Look Up Formula With Veried Search Range 2

Top