How do I get the alphabet be taken as 0 in formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display the alphabet in the table and want it to be taken as 0
during computation. How should I get this thing done?
 
Lots of worksheet functions will ignore alphanumeric entries.

=sum(a1:a10)

will ignore any text you have in A1:A10.

But you could be explicit when you need to be:

=n(a1)+n(a2)
 
You must log in or register to reply here.

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

How to type each letter of the alphabet automatically in a specific color in Word? 0
sheets in alphabetical order 2
Open File menu sort alphabetical. 6
Need formula to increase Alpha character to next letter 2
Excel How to Auto-Alphabetize a Specific Range in Excel? 1
How do I arrange cells in alphabetical order in Excel? 2
HOW DO I ALPHABETIZE MULTIPLE PAGES OF A SPREADSHEET? 3
Alphabetize? 1

Back
Top