| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a CASE statement in another spreadsheet?
"sebastienm" wrote ...
replace the Case statement by an IIF statement, eg: SELECT ActualApr05, iif( ActualApr05 <0, ActualApr05, 0) as QT105 FROM forecastcosts I can't see the CASE statement is needed e.g. apart from being less efficient, how is it different from SELECT ActualApr05, ActualApr05 AS QT105 FROM forecastcosts ? Jamie. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case Statement | Excel Discussion (Misc queries) | |||
| Select Case Statement | Excel Worksheet Functions | |||
| IF STATMENT OR CASE STATEMENT | Excel Discussion (Misc queries) | |||
| Case Statement Help | Excel Programming | |||
| Case statement | Excel Programming | |||
Threaded Mode
