| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to return a blank cell
Hello,
I have a column (say A), and next to that column, I create a column of formulas using = If(Type(A1)<2 and A10, 1, "") the problem is that "" is not a numerical format and I need a numerical format. Is there a value that would generate an empty cell that is not in string format? Thanks, Mr T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) | Excel Worksheet Functions | |||
| Formula to return position of the next Non-blank cell in a column | Excel Worksheet Functions | |||
| 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 | |||
Threaded Mode
