LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look Up and provide multiple result nsd Excel Discussion (Misc queries) 4 October 25th 09 01:10 AM
Function to treat formula result as blank cell JP[_3_] Excel Worksheet Functions 3 October 25th 07 06:26 PM
How create blank cell value as the result of Excel "IF" function? Pocket Protector as a Fashion Statement Excel Worksheet Functions 1 March 11th 07 07:44 PM
Provide a match from 2 cells to give a result from another leefarrell Excel Worksheet Functions 4 August 9th 06 01:31 PM
How do I Provide a specific result given multiple criteria? Luis Excel Worksheet Functions 1 July 14th 05 09:17 PM


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"