+ Reply to Thread
Results 1 to 4 of 4

Return formula instead of cell value using if function

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Return formula instead of cell value using if function

    Hello,

    I have a pivot table which has a formula beside it to calculate something. I need the formula to be copied below every time I refresh my pivot table with new data. I have tried using IF function but it will only display the value. Is there a way to display the formula using another formula?

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Return formula instead of cell value using if function

    There is a new Excel function FORMULATEXT but I do not think that was available in Excel2007

    Here is a UDF that does the same job
    Please Login or Register  to view this content.
    In attached workbook
    Formula in B2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Value shown in cell:
    =SUM(AB1+15)
    Attached Files Attached Files
    Last edited by kev_; 09-12-2017 at 12:14 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    08-14-2017
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Return formula instead of cell value using if function

    Thank you for sharing your knowledge Kev. I do appreciate it.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Return formula instead of cell value using if function

    You are welcome. Thanks for marking the thread SOLVED and for the rep.

+ 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] Function to return Formula from Cell Value
    By 1michael in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-14-2014, 05:50 PM
  2. formula to return blank cell - IF function
    By n1kk1 in forum Excel General
    Replies: 3
    Last Post: 12-17-2009, 08:14 AM
  3. [SOLVED] function CELL() to return the formula in the referenced cell
    By RagDyer in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 PM
  4. [SOLVED] function CELL() to return the formula in the referenced cell
    By Streep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] function CELL() to return the formula in the referenced cell
    By Streep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  6. function CELL() to return the formula in the referenced cell
    By Streep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] function CELL() to return the formula in the referenced cell
    By Streep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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