| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function with 3 arguments
Hello,
maybe some test values help you to decide which formula to take: macropod Biff_1 Biff_2 Avri_mod Bernd -1 5000 #N/A #N/A 5000 199999 5000 5000 5000 5000 5000 199999.99 10000 5000 5000 5000 5000 200000 10000 10000 10000 10000 10000 499999 10000 10000 10000 10000 10000 499999.99 15000 10000 10000 10000 10000 500000 15000 15000 15000 15000 15000 1.00E+300 15000 15000 15000 15000 15000 macropod =IF(C8<=199999,5000,IF(C8<=499999,10000,15000)) Biff_1 =LOOKUP(C8,{0,1,200000,500000},{"",5000,10000,1500 0}) Biff_2 =IF(C8=500000,15000,IF(C8=200000,10000,IF(C80,5 000,""))) Avri_mod =5000*MATCH(C8/1000,{0;200;500},1) Bernd =LOOKUP(C8,{-1E+300,200000,500000},{5000,10000,15000}) Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dates as function arguments in Excel | Excel Worksheet Functions | |||
| Function Arguments | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
