SWITCH Formula

L

Luis

How many expressions can i use with the SWITCH formula? I've been trying to use this formula with an extense table of expressions, but even though it lets me write the entire formula, it just doesn't lets close the formula parenthesis an marks an error. Is there any way to list a table of expressions an then look it up in that table?

Thanks
 
J

JackD

I think you are limited to 255 characters or around there.
Perhaps there is a way to simplify your formula or as an alternative use a
Visual Basic macro.

What does your formula do and what does it look like?

-Jack


Luis said:
How many expressions can i use with the SWITCH formula? I've been trying
Click to expand...
to use this formula with an extense table of expressions, but even though it
lets me write the entire formula, it just doesn't lets close the formula
parenthesis an marks an error. Is there any way to list a table of
expressions an then look it up in that table??
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
WORD VBA Search and switch to advanced ... 1
How to paste this down? 3
MS Project Import Error Row 1 Column 5 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word 2016 opening sooo slow 0
Start a mail merge upon opening the document 1
Merging from an Excel file with graphics 1

Top