| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get "####" when use alpha char in a cell referenced by a formula
On a timesheet, if a person did not work they have to type in why. However
this results in a "####" in the 'Total Hours' cell that contains the formula. If using alpha characters in a cell that is referenced by a formula, how can you get the result to just be a blank cell, and not the "####"? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| The Instruction at "0x749860a0" referenced memory at "0x00000000" | Excel Discussion (Misc queries) | |||
| Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell | Excel Worksheet Functions | |||
| how do I eliminate leading "0s" in an alpha numeric cell | Excel Discussion (Misc queries) | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Threaded Mode
