+ Reply to Thread
Results 1 to 3 of 3

Letters V or S equal to 0

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    2010
    Posts
    383

    Letters V or S equal to 0

    Hello,

    I would like to enter in a cell S (sick) or V (vacation) and when refer to that cell that it is considered as 0.

    As for now, When someone is sick or on vacation, I only put a 0 in the cell but by entering the "S" or "V" I could distinguis the vacation form the sickness.

    would you then know how to associate formulas with letter that woudl be consider as 0? and could I do a Sum of all S and V in my excel??

    Thanks,
    G

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,540

    Re: Letters V or S equal to 0

    You could use a SUM function and the S and V (being text) would be ignored.

    You could use a COUNTIF function to count all the S values (or V values).

    It is hard to give you a specific formula, as you have given no details about how your data is laid out - it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Please note that the Paperclip icon does not work.

    Hope this helps.

    Pete

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,905

    Re: Letters V or S equal to 0

    Suppose your data in "B2" ["S" or "V"]
    In "C2" formula :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. i need a formula for the sum of letters thart equal numbers
    By ERASHID in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2015, 05:45 AM
  2. [SOLVED] Reading the last 2 letters in a combobox value and enter those 2 letters into column
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-26-2013, 09:26 AM
  3. [SOLVED] Summing letters that equal numbers
    By M. McGee in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2013, 03:12 PM
  4. Replies: 5
    Last Post: 12-30-2012, 10:59 AM
  5. Replies: 2
    Last Post: 09-28-2011, 12:07 PM
  6. Making letters equal number values for semester and exam grades
    By Pfisch87 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2011, 07:44 PM
  7. I want a series of letters to equal a dollar amount?
    By awhitaker in forum Excel General
    Replies: 1
    Last Post: 05-17-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1