Nested IF fn Alternative

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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.
 
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
 
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?
 
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...
 
Back
Top