Nested IF fn Alternative

G

Guest

I am trying to string together IF functions to fulfill my requirements.
However if i need more than 7 conditions (from my understanding the nested IF
functions only go up to 7 cases) is there an alternative to this that would
give me the same results? Thanks
 
R

Ron Rosenfeld

I am trying to string together IF functions to fulfill my requirements.
However if i need more than 7 conditions (from my understanding the nested IF
functions only go up to 7 cases) is there an alternative to this that would
give me the same results? Thanks
Click to expand...

Yes there is.
--ron
 
I

iliace

The 7-function limit is true for all nested functions in versions
prior to 2007. What are the actual if conditions? There are several
techniques to circumvent this limitations, with nested IFs.
 
R

Ron Rosenfeld

Not unless you provide more information as to what you are trying to do. There
are any number of workarounds, but with the limited information you provided in
your initial post, it is difficult to advise you further.

If you don't want to supply any more information, you could look at VLOOKUP and
also at Chip Pearson's web site http://www.cpearson.com/excel.htm

can you specify?
Click to expand...


--ron
 
G

Guest

Ive figured out an alternative however another problem has occured. I have
used the CONCATENATE function to circumvent this problem however when i try
to format the number outputted it will not let me adjust it (if i wanted 2
decimal places or even change to a percent). I have conditional formatting
set but i doubt that will affect the decimal places? Any advice?
 
J

JE McGimpsey

Take a look at the TEXT() function.

Dave said:
Ive figured out an alternative however another problem has occured. I have
used the CONCATENATE function to circumvent this problem however when i try
to format the number outputted it will not let me adjust it (if i wanted 2
decimal places or even change to a percent). I have conditional formatting
set but i doubt that will affect the decimal places? Any advice?
Click to expand...
 

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

Nested if issue 1
Nested "If Statement" 4
Nested IF functions 5
Conditional nested formatting for cell color changes 1
Nested If 3
how can I exceed the nested if fuction limit 5
nested if with named formula 5
Nested Functions 7

Top