Posted to microsoft.public.excel.worksheet.functions

Corey

external usenet poster

Posts: 276

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Criteria problems in the DSUM function	AA	Excel Worksheet Functions	5	January 10th 06 10:16 PM
Countif Function, complex criteria	Tomski	Excel Worksheet Functions	4	January 9th 06 03:45 PM
Begins with as criteria in function	jhorsley	Excel Worksheet Functions	8	October 31st 05 05:32 PM
SumIf Function using multiple criteria	Jamie A Miller	Excel Worksheet Functions	1	February 4th 05 05:14 PM

All times are GMT +1. The time now is 09:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us