View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noncentz303 Noncentz303 is offline
external usenet poster
 
Posts: 14
Default 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