Excel should allow for significantly more than 8 arguments in the.

S

Shaddy

Many times I have to create a logical function involving a lot of variables,
usually employee numbers. I can make my work so much easier if I can just
type in the 4 digits and watch the data appear rather than using the
primitive sheets of paper that I now use. I cannot believe that Excel allows
for only eight "IF" arguments in one logical formula.
 
F

Frank Kabel

Hi
in nearly all cases instead of using more than 8 IF statements you
could use for example a lookup (using VLOOKUP) table or an algorithm.
Just provide some details about what you're trying to achieve and
you'll probably get a working solution
 

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

Yet More Excel VBA Help Please 0
Position of first number in array greater than a given number 4
More than 8 If statements in a command line in Excel 4
20080323 need help with an excel formula (with too many arguments!) 1
formula custom data validation 4
File Size - VBA vs Excel Formulas 7
WARNING: Opinion 4
Excel should allow more than 65,536 rows. 2

Top