+ Reply to Thread
Results 1 to 4 of 4

Add cell value to formula bar

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Add cell value to formula bar

    =IF(W12>=B15, "You have made 3 mistakes and lost this game. ","")
    In the above formula using the formula bar and where the number 3 is I want cell B15 or the value of cell B15 to go there

    thanks

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,162

    Re: Add cell value to formula bar

    How about
    Formula: copy to clipboard
    =IF(W12>=B15, "You have made "&B15&" mistakes and lost this game. ","")

  3. #3
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Re: Add cell value to formula bar

    Well, that was too easy. I am currently working on a Function that will exit the game after the number (3 in this case) has been reached, but ain't (Southern word) good with Functions but will post what I am working on later.
    Thanks again for your help.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,162

    Re: Add cell value to formula bar

    Glad to help & thanks for the feedback.

+ 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] Help Copying Formula from another cell, modifying formula and then pasting to new cell
    By TygerG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2021, 02:05 PM
  2. Replies: 8
    Last Post: 11-29-2017, 12:36 PM
  3. [SOLVED] If cell has a formula, copy text to TextBox and leave formula unchanged in cell
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2016, 06:26 PM
  4. Replies: 3
    Last Post: 07-14-2016, 03:53 PM
  5. [SOLVED] Formula to return Blank cell if referenced cell has no entries, if not use formula
    By stpeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2016, 01:41 PM
  6. [SOLVED] Enter formula result from one cell into a COUNTIF formula in another cell. Help please!
    By gregrach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  7. Replies: 5
    Last Post: 05-07-2013, 08:34 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