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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to return a blank cell
One way:
Instead of "", you could use a zero without quotes. Then set your worksheet so that it does not display zero values. This is done in Tools-Options. On the View tab, uncheck "zero values". HTH, Paul "MrT" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to return a blank cell
Thanks. That's interesting, but is not satisfactory in my case: I need to
reuse the values issued from the formulas to compute stats. Zeroes would false the result. Is there any other solution? "PCLIVE" wrote: One way: Instead of "", you could use a zero without quotes. Then set your worksheet so that it does not display zero values. This is done in Tools-Options. On the View tab, uncheck "zero values". HTH, Paul "MrT" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to return a blank cell
Many arithmetic functions ignore text.
But not in your case??? MrT wrote: Thanks. That's interesting, but is not satisfactory in my case: I need to reuse the values issued from the formulas to compute stats. Zeroes would false the result. Is there any other solution? "PCLIVE" wrote: One way: Instead of "", you could use a zero without quotes. Then set your worksheet so that it does not display zero values. This is done in Tools-Options. On the View tab, uncheck "zero values". HTH, Paul "MrT" wrote in message ... 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 -- Dave Peterson |
Reply |
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 |