+ Reply to Thread
Results 1 to 4 of 4

How to calculate if a cell has a certain word

  1. #1
    Forum Contributor
    Join Date
    10-01-2013
    Location
    United States
    MS-Off Ver
    Microsoft version 365
    Posts
    110

    How to calculate if a cell has a certain word

    I want to calculate where the icon is X as incomplete and when its a checkbox where it is complete. I want to put this on my dashboard page. Please help. See attached.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How to calculate if a cell has a certain word

    Try these:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Forum Contributor
    Join Date
    10-01-2013
    Location
    United States
    MS-Off Ver
    Microsoft version 365
    Posts
    110

    Re: How to calculate if a cell has a certain word

    Thank you. That worked.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How to calculate if a cell has a certain word

    No problem. Happy to help

    BSB

+ 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. [SOLVED] Excel to Word: Select only Word cell's text and not the cell range
    By Menohavename in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2020, 05:01 PM
  2. [SOLVED] Calculate Total Cost of value associated with a word
    By Chasermelb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-19-2016, 05:28 AM
  3. [SOLVED] Formula: If cell 3 is blank have cell 1 calculate, if cell 3 filled have cell 2 calculate
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-05-2016, 09:34 AM
  4. [SOLVED] Search for Word and Calculate Sum
    By Cansa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2013, 05:00 PM
  5. Check cell for word, If word exists in cell, assign that cell to corresponding category.
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 12:35 PM
  6. [SOLVED] How can I replace a word from a sentence in a cell & substitute word from another cell
    By rionoah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2012, 08:44 AM
  7. Replies: 9
    Last Post: 03-23-2010, 02:07 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