Please Help!!!! Need help with formula.

C

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
 
S

Spencer101

CNW;1605698 said:
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!
Click to expand...

Could you show us the formula you have so far
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quotation Mark preferences missing 0
Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Switch - Dollars to Words 0
Need Help with a VBA subroutine 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Need Help with Macro Security 1
Need some PWA help 0
Can't seem to delete all images from a Word Doc 2

Top