Closed Thread
Results 1 to 6 of 6

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

    Re: 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?
    Last edited by iantypas; 11-09-2018 at 04:56 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

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

    Not sure entirely what you are searching for, but sounds like...

    =IF(A1="Yes",B1,C1)

    Other than this, how about a sample workbook.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    HTH
    Regards, Jeff

  3. #3
    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"

    jeffreybrown,

    I originally posted this:

    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?

    I have attached the file
    Attached Files Attached Files
    Last edited by jeffreybrown; 11-09-2018 at 04:59 PM. Reason: Full quoting is not necessary!

  4. #4
    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"

    OK,
    The formula you need for Total Daily Hours is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Leo Skywalker
    May the force be with you.

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

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

    is this different than this other post of yours?
    https://www.excelforum.com/for-other...ml#post5007823
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

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

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. 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
  3. If cell equals "x" move row to sheet "x", If cell equals "y" move row to sheet "y"
    By snappyleon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-01-2013, 03:19 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

Tags for this Thread

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