Getting Rid of values like TRUE and 0 when using functions
 

I have a table that is full of IF() statements and other conditional
statements. But when I dont have a value that plugs into the statement I get
a TRUE value in the box. Is there a way to make my function so that if there
is no value to plug in the cell just stays blank

..... I also get this same problem but instead of TRUE its 0 that comes up

Getting Rid of values like TRUE and 0 when using functions
 

Try something like this:

=IF(A1="","",your_formula_here)

Biff

"Noncentz303" wrote in message
...
I have a table that is full of IF() statements and other conditional
statements. But when I dont have a value that plugs into the statement I
get
a TRUE value in the box. Is there a way to make my function so that if
there
is no value to plug in the cell just stays blank

.... I also get this same problem but instead of TRUE its 0 that comes up

Getting Rid of values like TRUE and 0 when using functions
 

"T. Valko" wrote:

Try something like this:

=IF(A1="","",your_formula_here)

Biff

"Noncentz303" wrote in message
...
I have a table that is full of IF() statements and other conditional
statements. But when I dont have a value that plugs into the statement I
get
a TRUE value in the box. Is there a way to make my function so that if
there
is no value to plug in the cell just stays blank

.... I also get this same problem but instead of TRUE its 0 that comes up