| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Designer dummy in Excel - Need (nested?) If statement...
Assuming you can put Y for "yellow" in cell D6, type the following
formula in cell X6: =IF(D6="Y",20,IF(C6D6,(C6-D6)*5,IF(C6<D6,(D6-C6)*10,"Equal"))) You do not specify what you want to happen when C6 = D6, so this formula returns "Equal", but you can change this to what you want. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Excel IF statement to a different worksheet? | Excel Discussion (Misc queries) | |||
| Can I import my business banking statement online into excel? | New Users to Excel | |||
| how fill adatabasein domino designer with information of excel | Excel Worksheet Functions | |||
| SQL Statement and Excel | Charts and Charting in Excel | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
