Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn formula into Select
Can someone turn the following formula into a select statement:
IF(ISBLANK(M4),"",IF(ISNUMBER(--MID(M4,2,1)),"Manual","Auto")) Basically I'm tagging a record based on a value, if the second character in the string contained in the specific column (field) is a number I want this column to say "Manual" esle Auto and leave blank if no value. I'm migrating this report into BI and I can't figure out how to do this in their interface, but I can write select statement for it. It will be a calculation based on the field containing the data. Thanks -- Hile |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you turn off the formula bar? | New Users to Excel | |||
Want formula to turn to value by itself | Excel Discussion (Misc queries) | |||
Can I turn off the auto-select in Functions? | Excel Worksheet Functions | |||
Turn Off Formula ? | New Users to Excel | |||
Turn OFF Formula Bar??? | Excel Programming |