If Function. How to Add more criteria

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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,IF(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.
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help on replacing this formula 6
seperate first 2 lines of column in seperate columns in same row 2
If Function with multiple criteria 2
How to create a bubble chart with more than 2 variables 0
If Function 6
I need to add one more criteria to this function 4
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" 5
IF Function Help 3

Back
Top