| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0)
I have tried every method I can think of to return a blank cell as the result
of a formula EXAMPLES: IF($D31,D3,"") HOPING "" COULD BE INTERPRETED AS EMPTY STRING (BLANK IF($D31,D3,A2) WHERE A2 IS A BLANK CELL NO MATTER WHAT I TRY, XL AWAYS RETURNS 0'S ... THIS DOESN'T WORK FOR MY APPLICATION. I CAN'T SEEM TO FIND A WAY TO HAVE A FORMULA RETURN A BLANK CELL. ANY HELP IS GREATLY APPRECIATED !!! THANKS ... GEORGE ZEIGLER, SAN DIEGO. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| When I have a formula in a cell, how can I make it come up blank? | Excel Discussion (Misc queries) | |||
| Formula ? Return value from rightmost non-blank cell in a row of | Excel Worksheet Functions | |||
| Return blank cell using a formula | New Users to Excel | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
Threaded Mode
