Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to utilize a logical expression to yield this result:
If the field is blank return a value of no, if there is anything at all in the field return the value of yes. Basically, I am pulling data out of a database for a checklist. The user only cares if there is or is not data in that field. So I am trying to convert the data to a YES and a blank field to a NO. I would greatly appreciate any assistance. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero replaces blank field when paste special is used | Excel Worksheet Functions | |||
Blank field formatted as date | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Displaying blank field instead of #N/A | Excel Discussion (Misc queries) | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) |