| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
"Tip #10 Too many Nested IF's Something that goes unnoticed when trying to figure out how to fit more than seven IF statements into one formula is that most of the time you can use VLOOKUP or some other LOOKUP formula instead. VLOOKUP can LOOKUP exact matches or LOOKUP values in a range as in greater than 10 but less than 20. See if it will work for you." From http://excelchampion.com/tips.htm -- ExcelChampion ------------------------------------------------------------------------ ExcelChampion's Profile: http://www.officehelp.in/member.php?userid=5096 View this thread: http://www.officehelp.in/showthread.php?t=1261683 Posted from - http://www.officehelp.in |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
