| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statments: Want TRUE if a value = any of the given values | Excel Worksheet Functions | |||
| how do I put in the IF function only integer as true values? | Excel Worksheet Functions | |||
| Summing Values that are True and Not Rounded | Excel Discussion (Misc queries) | |||
| Create a function to return text if two logical functions are true | Excel Worksheet Functions | |||
| Multiple If True Values? | Excel Discussion (Misc queries) | |||
Threaded Mode
