+ Reply to Thread
Results 1 to 6 of 6

Link cell value depending on Yes/No

Hybrid View

  1. #1
    Registered User
    Join Date
    06-07-2017
    Location
    Denmark
    MS-Off Ver
    Excel 2016
    Posts
    4

    Link cell value depending on Yes/No

    Okay, so the thing is.
    I'm making a sheet for me and some friends where we bet on football
    So I would like values to go into a certain cell but only if the bet is won.

    So I have a table with names, potential outcome, Win or Loss

    on my frontpage I have the total amount of money gambled and then i would like that subtracted for the amount of money the given person has won, but ONLY if the bet is won. How do i do that?

    How do I make a cells value dependant on a number of factors?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,079

    Re: Link cell value depending on Yes/No

    Attach a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
    Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-07-2017
    Location
    Denmark
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Link cell value depending on Yes/No

    There it is
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-07-2017
    Location
    Denmark
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Link cell value depending on Yes/No

    I also wrote a note in the file. Thank you for your time!

  5. #5
    Registered User
    Join Date
    06-07-2017
    Location
    Denmark
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Link cell value depending on Yes/No

    !Bump!

    Please help me

  6. #6
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,079

    Re: Link cell value depending on Yes/No

    Sheet 1 Forside has 1 row for Kevin
    But Sheet 2 Odds uge pr uge has multiple rows for Kevin.

    You say you want the values "transferred".
    What do you mean by this?
    Added together?
    Or do you want multiple rows produced for Kevin on tab 1 ?
    If you want multiple rows then the Additional Stats table is going to be in the way.
    Either move it to a new sheet or position it out of the way as it is not clear how many multiple rows will be needed.

+ 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. Replies: 0
    Last Post: 01-20-2017, 01:53 PM
  2. [SOLVED] Activex Option Button - link to multiple cells depending on input from another cell?
    By scrawl.to.me in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2015, 03:26 PM
  3. Replies: 5
    Last Post: 08-14-2013, 06:16 AM
  4. Replies: 12
    Last Post: 03-31-2013, 07:13 PM
  5. Replies: 4
    Last Post: 07-19-2012, 04:47 PM
  6. Link picture to a server path depending on a cell reference
    By Kraecki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2011, 08:49 AM
  7. [SOLVED] if i sort cell that has link to another page how to keep link
    By steve Bahrain in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 08:25 AM

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