Home 
Search 
Today's Posts 
#1




Leaving an empty cell empty
Using an "IF" formula, I need to leave empty the empty cells (I mean, cells
containing nothing). I tried many ways, f.e., putting a "" if the formula finds and empty cell, but Excel (2003) puts something all the times. Thanks to all. Giovanni 
#2




Leaving an empty cell empty
"GRL" wrote in message
... Using an "IF" formula, I need to leave empty the empty cells (I mean, cells containing nothing). I tried many ways, f.e., putting a "" if the formula finds and empty cell, but Excel (2003) puts something all the times. Thanks to all. Giovanni Look at this formula: =IF($A14=0,"",$A14*G14) See the two commas in the middle, surrounding the double quotation marks? Do you have something like that in your formula? 
#3




Leaving an empty cell empty
=IF(A1="","",IF(A1=1,0,1))
HTH  AP "GRL" a écrit dans le message de ... "Doug Kanter" ha scritto nel messaggio ... "GRL" wrote in message ... Using an "IF" formula, I need to leave empty the empty cells (I mean, cells containing nothing). I tried many ways, f.e., putting a "" if the formula finds and empty cell, but Excel (2003) puts something all the times. Thanks to all. Giovanni Look at this formula: =IF($A14=0,"",$A14*G14) See the two commas in the middle, surrounding the double quotation marks? Do you have something like that in your formula? Thank you, but my problem is a little more complex: I have a column with all the cells containing only "1" or "0" or being empty. I need to reverse the "1"'s into "0"'s, and vice versa, and to leave the empty cells as they are. I'm not able to find how to do it. Giovanni 
#4




Leaving an empty cell empty
"GRL" wrote in message ... "Doug Kanter" ha scritto nel messaggio ... "GRL" wrote in message ... Using an "IF" formula, I need to leave empty the empty cells (I mean, cells containing nothing). I tried many ways, f.e., putting a "" if the formula finds and empty cell, but Excel (2003) puts something all the times. Thanks to all. Giovanni Look at this formula: =IF($A14=0,"",$A14*G14) See the two commas in the middle, surrounding the double quotation marks? Do you have something like that in your formula? Thank you, but my problem is a little more complex: I have a column with all the cells containing only "1" or "0" or being empty. I need to reverse the "1"'s into "0"'s, and vice versa, and to leave the empty cells as they are. I'm not able to find how to do it. Giovanni Except for the problem with empty cells, does your formula work otherwise? If yes, please post the formula here. 
#5




Leaving an empty cell empty
This is the solution!
Thank you, Ardus, and thank you all. Giovanni "Ardus Petus" ha scritto nel messaggio ... =IF(A1="","",IF(A1=1,0,1)) HTH  AP "GRL" a écrit dans le message de ... "Doug Kanter" ha scritto nel messaggio ... "GRL" wrote in message ... Using an "IF" formula, I need to leave empty the empty cells (I mean, cells containing nothing). I tried many ways, f.e., putting a "" if the formula finds and empty cell, but Excel (2003) puts something all the times. Thanks to all. Giovanni Look at this formula: =IF($A14=0,"",$A14*G14) See the two commas in the middle, surrounding the double quotation marks? Do you have something like that in your formula? Thank you, but my problem is a little more complex: I have a column with all the cells containing only "1" or "0" or being empty. I need to reverse the "1"'s into "0"'s, and vice versa, and to leave the empty cells as they are. I'm not able to find how to do it. Giovanni 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Custom functions calculating time arguments Help Desperate  Excel Worksheet Functions  
Blank (empty) cell always equal to 0??  Excel Discussion (Misc queries)  
How do I set a cell to "Empty" so that it does not display in a ch  Charts and Charting in Excel  
make a cell empty based on condition  Charts and Charting in Excel  
GET.CELL  Excel Worksheet Functions 