| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit on Logic
Short and to the point. Thanks much.
Thanks to everyone else who posted as well, it is appreciated. "Jim Cone" wrote: =MIN(D2*25,250) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Nash13" wrote in message I am trying to build a logic statement with 11 arguments. We are using Excel 2003 which I am assuming has a limit on 7 such arguments. I've attached my formula below, how can I bypass these limits? Thank you =IF(D2=10,"250",IF(D2=9,"225",IF(D2=8,"200",IF( D2=7,"175",IF(D2=6,"150",IF(D2=5,"125",IF(D2=4 ,"100",IF(D2=3,"75",IF(D2=2,"50",IF(D2=1,"25",I F(D2=0,"0","N/A")))))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Then logic help | Excel Worksheet Functions | |||
| If Then logic not enough | Excel Discussion (Misc queries) | |||
| IRR Logic | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
| IF THEN LOGIC | Excel Discussion (Misc queries) | |||
Threaded Mode
