| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation in IF string
Does anyone know how to include a LIST (Validation) in an If string?
e.g. =if (J12="M"; "N.A"; LIST["Pool balance"; "Account balance"]) i.e. if J12 not equal to M then I would like the user to chose between "pool balance" and "accountr balance" / J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Mind-numbing simple data validation ... string from 1 to 64 chars | Excel Worksheet Functions | |||
| How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Threaded Mode
