| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested If problems
Greetings:
Have the following, (used on multiple lines, in multiple workbooks) Works great =IF(D6="Alum",130,IF(D6="Rubber",145,0)) Need to expand it as follows: =IF($E$5=0 then (D6="Alum",130,IF(D6="Rubber",145,0)) =IF($E$5=1 then =IF(D6="Alum",60,IF(D6="Rubber",70,0)) Have spent countless hours trying to "join" the above - playing with the brackets and moving the Zero around, etc.... I'm STUCK. I'm positive this should work if properly bracketted. Due to the "application", I'd rather not change this to a look-up chart. Thank-you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Formulas In Cells That Are Not Nested | Excel Discussion (Misc queries) | |||
| Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
| Experienced any problems with nested subtotals using Windows XP | Excel Worksheet Functions | |||
| Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
