"IF" Function

  • Thread starter Thread starter powler
  • Start date Start date
P

powler

I am "IF" Function in Excel Sheet.
It doesnt allows you to put more than 7 argumanets. That is you ca
repeat IF only 7 times in single cell.

Can anybody help me out to overcome this problem.

How to put more than 7 arguments.

Regards,

Ton
 
Try explaining what you want to accomplish and many experts here can give
you a work around.
 
Hi Powler!

Most often the solution will be to use VLOOKUP. That will apply way
before you hit the nested function limit.
 

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

Nesting Functions 4
Function Has Too Many Arguments 4
Use of IF function 4
Alternative to the limitations of the 'IF' function in Excel? 3
Question about Combin function 3
Max amount of "IF" statements 2
How fix a too long array function 5
Still using Excel 2000. How to nest more than 7 in IF formula 1

Back
Top