If Function. How to Add more criteria
 

Is it posible to add more If functions to a single If calc ?

I need to add, if i can to the below :
=IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,I F(D58=R72,AJ72,IF(D58=R73,AJ73,IF(D58=R74,AJ74,IF( D58=R75,AJ75,IF(D58=R76,AJ76))))))))

I want to add about another 26 IF's to this.

Can i some how?


If i try anymore i get an error, but the above seems to be the limit.

--
Regards

Corey

If Function. How to Add more criteria
 

HI

The attached should help

http://www.j-walk.com/ss/excel/usertips/tip080.htm

http://www.cpearson.com/excel/nested.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561357

If Function. How to Add more criteria
 

Hi!

Try this:

=INDEX(AJ69:AJ102,MATCH(D58,R69:R102,0))

Biff

"Corey" wrote in message
...
Is it posible to add more If functions to a single If calc ?

I need to add, if i can to the below :
=IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,I F(D58=R72,AJ72,IF(D58=R73,AJ73,IF(D58=R74,AJ74,IF( D58=R75,AJ75,IF(D58=R76,AJ76))))))))

I want to add about another 26 IF's to this.

Can i some how?


If i try anymore i get an error, but the above seems to be the limit.

--
Regards

Corey

If Function. How to Add more criteria
 

thanks Biff

To easy once ya know....


Corey.....

If Function. How to Add more criteria
 

You're welcome!

Biff

"Corey" wrote in message
...
thanks Biff

To easy once ya know....


Corey.....

If Function. How to Add more criteria
 

=INDEX(AJ69:AJ76,MATCH(D58,R69:R76,0))

just extend the 76 part.

If it might not match add error checking

=IF(ISNA(MATCH(D58,R69:R76,0)),"No
match",INDEX(AJ69:AJ76,MATCH(D58,R69:R76,0)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" wrote in message
...
Is it posible to add more If functions to a single If calc ?

I need to add, if i can to the below :

=IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,I F(D58=R72,AJ72,IF(D58=R73,
AJ73,IF(D58=R74,AJ74,IF(D58=R75,AJ75,IF(D58=R76,AJ 76))))))))

I want to add about another 26 IF's to this.

Can i some how?


If i try anymore i get an error, but the above seems to be the limit.

--
Regards

Corey