EXCELL, "IF" FORMULA

[dave8664]

I AM TRYING TO USE THE IF FORMULA TO CHANGE THE TEXT IN CELL D1,TO A DESCRIPTION BASED ON A VAULE IN CELL C1.EXAMPLE: =IF(C1=1,F1,IF(C1=2,F2))
CELLS IN THE F COLUMN HAVE THE DESCRIPTION
TO MATCH THE VALUES OF 1 OR 2 OR SO ON.
I NEED TO HAVE MANY IF VALUES, 100 OR SO. THE IF FUNCTION ONLY ALLOWS FOR 7 VAULES DO I USE VLOOKUP? OR SOMETHING ELSE.

 

[Joe Was]

You are right each cells "If statement" can only have seven nested IF's but the last "IF" can direct the next condition to an additional cell(s). Each additional cell containing seven more "If's."

Also your sample is incorrect your last "If" needs a "then" condition result, IF(test,then,else) syntax!

If(test,then,If(test,then,else))

Yes, I would use a "VLookUp" in your case. JSW

 

[maxflia10]

On 2002-09-04 10:07, dave8664 wrote:
I AM TRYING TO USE THE IF FORMULA TO CHANGE THE TEXT IN CELL D1,TO A DESCRIPTION BASED ON A VAULE IN CELL C1.EXAMPLE: =IF(C1=1,F1,IF(C1=2,F2))
CELLS IN THE F COLUMN HAVE THE DESCRIPTION
TO MATCH THE VALUES OF 1 OR 2 OR SO ON.
I NEED TO HAVE MANY IF VALUES, 100 OR SO. THE IF FUNCTION ONLY ALLOWS FOR 7 VAULES DO I USE VLOOKUP? OR SOMETHING ELSE.

Dave,

If you have unique look up vales (1, 2)that translates into description, then use VLOOKUP. However if you have only values 1 and 2 describing more than 2 things, the another route you must take!

Book1
	A	B	C	D
1	1	red	3	blue
2	2	green
3	3	blue
4	4	yellow
Sheet1

 

[Jim North]

You could also use OFFSET:

Assuming your data starts in C1, and your descriptions start in F1.

=OFFSET($C$1,C1-1,3)

Book1
	B	C	D	E	F	G
1		1	test1		test1
2		2	test2		test2
3		3	test3		test3
4		4	0
5
Sheet1

 

[IML]

Also,
=INDIRECT("f"&C1)
may work for you. Generally, try to avoid the use of volotile functions such as this, but sometimes they fit the bill.

Good luck.

 

[Aladin Akyurek]

On 2002-09-04 10:07, dave8664 wrote:
I AM TRYING TO USE THE IF FORMULA TO CHANGE THE TEXT IN CELL D1,TO A DESCRIPTION BASED ON A VAULE IN CELL C1.EXAMPLE: =IF(C1=1,F1,IF(C1=2,F2))
CELLS IN THE F COLUMN HAVE THE DESCRIPTION
TO MATCH THE VALUES OF 1 OR 2 OR SO ON.
I NEED TO HAVE MANY IF VALUES, 100 OR SO. THE IF FUNCTION ONLY ALLOWS FOR 7 VAULES DO I USE VLOOKUP? OR SOMETHING ELSE.

If the domain of C1 are integers that obey the rule 1, 2, 3,..., then you could also use in D...

=INDEX(F-range,C1)