Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function. How to Add more criteria
thanks Biff
To easy once ya know.... Corey..... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function. How to Add more criteria
You're welcome!
Biff "Corey" wrote in message ... thanks Biff To easy once ya know.... Corey..... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Criteria problems in the DSUM function | Excel Worksheet Functions | |||
Countif Function, complex criteria | Excel Worksheet Functions | |||
Begins with as criteria in function | Excel Worksheet Functions | |||
SumIf Function using multiple criteria | Excel Worksheet Functions |