Please Help!!!! Need help with formula.

[CNW]

I have blank cells that I replaced with "-". I have a formula usin
those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get th
formula to recognize "-" as zero? Thanks in advance for any help

 

[Spencer101]

I have blank cells that I replaced with "-". I have a formula usin
those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get th
formula to recognize "-" as zero? Thanks in advance for any help!

Could you show us the formula you have so far

 

[tomeckstein]

Insert if statement to look at cell. ---if(cell='-',0,cell)

 

[tomeckstein]

Insert if statement into equation to check for dash.
If(cell='-', 0,cell)