+ Reply to Thread
Results 1 to 10 of 10

Display cell value only if another cell value equals "Yes"

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Display cell value only if another cell value equals "Yes"

    Hello all,

    I am building a Google Sheets hourly work count that would show total hours/pay. I need to display the calculation based on the response to other cell.

    For example:

    If user inputs rota for the whole month, excel would count all the hours. However, I want it to show that calculation only if "Shift Complete?" cell says "Yes" ("Shift Complete?" cell will have a drop down that show "Yes" and "No").

    Any ideas as to the best way to execute this?

  2. #2
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    148

    Re: Display cell value only if another cell value equals "Yes"

    Use:

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

    Where ShiftComplete is the reference to the ShiftComplete cell, and CalculatedHours is the calculation or reference to the calculation.
    Leo Skywalker
    May the force be with you.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Display cell value only if another cell value equals "Yes"

    Since thsi is a Google Sheets question I'll move the thread to the Other Platforms forum
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Re: Display cell value only if another cell value equals "Yes"

    It doesn't work. If you would like I can give you access to the sheet and you can try yourself?

  5. #5
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    148

    Re: Display cell value only if another cell value equals "Yes"

    Quote Originally Posted by iantypas View Post
    It doesn't work. If you would like I can give you access to the sheet and you can try yourself?
    OK, give me access to the sheet

  6. #6
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Re: Display cell value only if another cell value equals "Yes"

    For some reason I can't post links because I am new to here

  7. #7
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Re: Display cell value only if another cell value equals "Yes"

    Quote Originally Posted by Richard Buttrey View Post
    Since thsi is a Google Sheets question I'll move the thread to the Other Platforms forum
    Is it possible to post links here? I cant post any as its not allowing me

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Display cell value only if another cell value equals "Yes"

    Quote Originally Posted by iantypas View Post
    Is it possible to post links here? I cant post any as its not allowing me
    Yes of course it's possible to post links. The Link icon is the little icon that looks like a globe. However why not upload the google sheets file here and make it easier?

  9. #9
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Re: Display cell value only if another cell value equals "Yes"

    Quote Originally Posted by Richard Buttrey View Post
    Yes of course it's possible to post links. The Link icon is the little icon that looks like a globe. However why not upload the google sheets file here and make it easier?
    It doesn't allow me.

    It keeps saying:

    You are not allowed to post any kinds of links, images or videos until you post a few times.
    EDIT: I can't upload files either :/

  10. #10
    Registered User
    Join Date
    11-09-2018
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    8

    Re: Display cell value only if another cell value equals "Yes"

    LeoSkywalker,

    I have sent you a PM.
    Last edited by jeffreybrown; 11-09-2018 at 05:11 PM. Reason: Removed quote!

+ 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. Display cell value only if another cell value equals "Yes"
    By iantypas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2018, 05:10 PM
  2. [SOLVED] If cell equals "CR" then make cell to left negative and delete "CR".......
    By pasqualebaldi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 07:51 PM
  3. Check if A1 equals the sum of A2+A3 display "correct" if not "Try again"
    By eatmydust in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2014, 09:14 AM
  4. [SOLVED] Countif a cell equals "x" and cell above is "y"
    By Bishonen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2013, 07:35 AM
  5. [SOLVED] Delete row if cell in Column N equal "Different" or Column P equals "Blank"
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2012, 08:25 AM
  6. Replies: 11
    Last Post: 02-08-2012, 12:36 PM
  7. Replies: 2
    Last Post: 11-17-2010, 12:09 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