| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IF statements
Hi gang,
my head is spinning around...what would be the best way to write this one? In cell D20: IF J9<7,D20=J9 IF J9=7,D20=0 IF J97<14,D20=J9-D21 IF J9=14, D20=0 IF J914<28,D20=J9-D21 IF J9=28, D20=0 IF J928<42,D20=J9-D21 IF J9=42, D20=0 IF J942<56, D20=J9-D21 thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| Using multiple IF statements | Excel Discussion (Misc queries) | |||
| sum of multiple IF statements | Excel Worksheet Functions | |||
| multiple if statements | Excel Discussion (Misc queries) | |||
| multiple IF statements | Excel Worksheet Functions | |||
Threaded Mode
