"IF" Function

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
 
J

JON JON

Try explaining what you want to accomplish and many experts here can give
you a work around.
 
N

Norman Harker

Hi Powler!

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