| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing an IF statement in Microsoft Query
I'm querying our Oracle data to Excel and can't seem to get a formula return
as a new field. I need the proper way to write this sequence: IF(RM.RM_STD= "LOCKER",50,RM.RM_AREA*RMSTD.COST_OF_SPACE) Which would basically say that if the room standard is a locker, we charge $50 - otherwise, take the room area and multiply it by the cost per square foot. But it doesn't matter how I write it...it's not working! HELP??!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing a query | Excel Discussion (Misc queries) | |||
| Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
| Writing IF Statement | Excel Worksheet Functions | |||
| writing a statement | Excel Worksheet Functions | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Threaded Mode
