| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Contents of cell
Cell a1 is a formula that looks at another cell and returns a date or ""
(nothing) Cell a2 is a formula that looks at another cell and returns a number or "" (nothing) Now I need a formula that looks at a1 and if the result equals "" then return a2 otherwise return a1. Any help will be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
