Nested IF fn Alternative
 

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

Nested IF fn Alternative
 

On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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

Nested IF fn Alternative
 

can you specify?

"Ron Rosenfeld" wrote:

On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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

Nested IF fn Alternative
 

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.


On Aug 20, 1:18 pm, Ron Rosenfeld wrote:
On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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

Nested IF fn Alternative
 

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

On Mon, 20 Aug 2007 10:36:04 -0700, Dave
wrote:

can you specify?

"Ron Rosenfeld" wrote:

On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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



--ron

Nested IF fn Alternative
 

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?

"iliace" wrote:

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.


On Aug 20, 1:18 pm, Ron Rosenfeld wrote:
On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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

Nested IF fn Alternative
 

Take a look at the TEXT() function.

In article ,
Dave wrote:

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?

"iliace" wrote:

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.


On Aug 20, 1:18 pm, Ron Rosenfeld wrote:
On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

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