Nested IF fn Alternative

[Dave]

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

 

[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

Yes there is.
--ron

 

[Dave]

can you specify?

Yes there is.
--ron

 

[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.

 

[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?

--ron

 

[Dave]

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?

 

[JE McGimpsey]

Take a look at the TEXT() function.

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?