View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
[email protected] jackzach@gmail.com is offline
external usenet poster
 
Posts: 1
Default Please Help!!!! Need help with formula.

On Thursday, September 20, 2012 at 10:52:32 AM UTC-5, CNW wrote:
I have blank cells that I replaced with "-". I have a formula using
those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get the
formula to recognize "-" as zero? Thanks in advance for any help!




--
CNW


if(cell="-",0,cell)