Posted to microsoft.public.excel.worksheet.functions

Kelvin Pek Kelvin Pek is offline

external usenet poster

Posts: 1

Nested And function

I i have more than 7 nested level like the following what can be done?
=IF(AND(F11="Ma",G11="R"),"M",
(IF(AND(F11="Ma",G11="O"),"H",
IF(AND(F11="Ma",G11="F"),"H",
IF(AND(F11="Mo",G11="R"),"L",
IF(AND(F11="Mo",G11="O"),"M",
IF(AND(F11="Mo",G11="F"),"H",
IF(AND(F11="Mi",G11="R"),"L",.....))))))))

Actually i only have 9 level and so i am shortfall of 2 to complete my
formulas.... andyone can help????

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
Nested IF Function	Marco Margaritelli	Excel Worksheet Functions	7	July 31st 06 07:54 AM
Problem with nested if function. PLS HELP	sfar007	Excel Worksheet Functions	2	June 6th 06 11:34 AM
Offset function with nested match function not finding host ss.	MKunert	Excel Worksheet Functions	1	March 21st 06 10:46 PM
Nested IF Function and VLookup Alternatives	robert.holmes	Excel Worksheet Functions	1	December 12th 05 10:28 PM
Countif Function -Nested	Angi	Excel Discussion (Misc queries)	7	May 4th 05 07:04 PM

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us