| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does a function provide a blank cell as a result
Within an IF function, I would like to have the cell left blank given a
certain logical result. The purpose is to have a result, that does not show up as a zero in a chart. Using "" in the function will make the chart function perceive the value of the cell as a zero instead of a completely blank cell (i.e. as after having hit Delete, while being in the cell). How is that done??? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How does a function provide a blank cell as a result
Hi Rene
Use NA() for your false result rather than "" =IF(A10,25,NA()) -- Regards Roger Govier Rene B. wrote: Within an IF function, I would like to have the cell left blank given a certain logical result. The purpose is to have a result, that does not show up as a zero in a chart. Using "" in the function will make the chart function perceive the value of the cell as a zero instead of a completely blank cell (i.e. as after having hit Delete, while being in the cell). How is that done??? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How does a function provide a blank cell as a result
As the =SERIES() won't read N/A error the chart won't produce results
for them... On May 31, 4:13*pm, Roger Govier wrote: Hi Rene Use NA() for your false result rather than "" =IF(A10,25,NA()) -- Regards Roger Govier Rene B. wrote: Within an IF function, I would like to have the cell left blank given a certain logical result. The purpose is to have a result, that does not show up as a zero in a chart. Using "" in the function will make the chart function perceive the value of the cell as a zero instead of a completely blank cell (i.e. as after having hit Delete, while being in the cell). How is that done??? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look Up and provide multiple result | Excel Discussion (Misc queries) | |||
| Function to treat formula result as blank cell | Excel Worksheet Functions | |||
| How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
| Provide a match from 2 cells to give a result from another | Excel Worksheet Functions | |||
| How do I Provide a specific result given multiple criteria? | Excel Worksheet Functions | |||
Linear Mode
