+ Reply to Thread
Results 1 to 2 of 2

Output result to another cell

  1. #1
    Registered User
    Join Date
    03-30-2019
    Location
    Perth, Western Australia
    MS-Off Ver
    O365
    Posts
    1

    Output result to another cell

    Hi All,

    I don't know if this is a common and silly question, however, i would like to check if a cell is blank/empty and if so write some text in it, however, i want to put the formula in a hidden cell and and have it check another cell and output the text there...

    e.g. Put the formula in A1 to check if B1 is blank and if it is blank automatically add "put your text here" in B1

    Hope this makes sense? Is this possible without macro's etc?

    OR is there a better way to achieve this outcome?

    Cheers,
    Darren
    Last edited by ithink; 03-30-2019 at 07:27 AM.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Output result to another cell

    Hi Darren.

    What you're asking is not possible without vba (a macro).

    A formula can only show a result in the cell that you put it in, it cannot send it to another cell.

    The only thing that 'might' work would be to enter your message into A1, then format as 'Center across selection' so that it spans B1 as well.

+ 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] Data Link for output cell as a result of sumproduct..
    By kundanlal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2016, 10:54 AM
  2. Output formula result
    By shawnvon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2014, 07:40 PM
  3. Search cell text and output different values based on result in another cell
    By tbarn1980 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 09:54 PM
  4. Output result from formula into different cell
    By jdeboef in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 03:06 PM
  5. Search A Cell And Output A Result From An Array
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-03-2011, 08:24 AM
  6. output formula result into another cell
    By JMW123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2011, 08:44 AM
  7. Output result of a formula to a different cell?
    By nawu in forum Excel General
    Replies: 15
    Last Post: 04-03-2011, 09:12 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