View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
 
Posts: 276
Default 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