+ Reply to Thread
Results 1 to 9 of 9

Function to convert function into text with values?

  1. #1
    Registered User
    Join Date
    02-27-2016
    Location
    Germany
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Question Function to convert function into text with values?

    Hello,

    is it possible to convert a function into text with its values?

    Some function like FORMULATEXT() but it should display the values instead of A1, A2 etc

    I attach a picture to show what i mean
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Function to convert function into text with values?

    If I understand correctly you would like B2 to display 1*2*3. If so put this formula in B2:
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-27-2016
    Location
    Germany
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Re: Function to convert function into text with values?

    Yes, that is correct.

    But Im looking for a macro or formula which creates the expression automatically because if you have many and long formulas it will be very exhausting

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Function to convert function into text with values?

    for Ex2013 and above:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    for less then Ex2013:
    Please Login or Register  to view this content.
    usage: ShowFormula(A1)

    edit:
    I lost Value instead A1,A2 etc. sorry

    here is:
    insert in standard module
    Please Login or Register  to view this content.
    usage: =LiteralFormula(A1)

    formula: =A1*A2+A3
    result: 2*4+7
    Last edited by sandy666; 02-27-2016 at 06:13 PM.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Function to convert function into text with values?

    To multiply values use PRODUCT function

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    v A B
    1 1
    2 2 6
    3 3
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Function to convert function into text with values?

    What about writing a formula that would allow you to put values in the first 10 rows of column A and then automatically put an asterisk in column B corresponding to whether or not the cell to the left AND the cell to the left and down have values, like this:
    Show the formula.xlsx
    Here is the formula for B1 through B9:
    Please Login or Register  to view this content.
    Here is the formula for C2 (which incorporates AlKey's answer):
    Please Login or Register  to view this content.
    Test it out by adding a number to A6 or deleting the number in A5.
    Let me know if you have any questions.

  7. #7
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Function to convert function into text with values?

    A simple User Defined Function is all you need.

    Please Login or Register  to view this content.

    Or you could use a simple function:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 02-27-2016 at 06:31 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  8. #8
    Registered User
    Join Date
    02-27-2016
    Location
    Germany
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Re: Function to convert function into text with values?

    Quote Originally Posted by sandy666 View Post
    formula: =A1*A2+A3
    result: 2*4+7
    Thats exactly what i was looking for
    Thank you so much!

    (thanks for all the other responses too )

  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Function to convert function into text with values?

    Glad to help
    One more thing: it doesn't work with $$, like $A$1 but A1. I think it is not a big problem

+ 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. Convert Text to numbers using function ?
    By hanialbarni in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-13-2015, 07:58 PM
  2. Create Function to Convert Certain Text to Uppercase
    By wwconslt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2015, 09:09 PM
  3. Replies: 1
    Last Post: 04-24-2014, 12:25 AM
  4. Using text function to convert time to minutes
    By koochandkai in forum Excel General
    Replies: 2
    Last Post: 08-09-2011, 08:28 AM
  5. [SOLVED] Function to Convert dollar to text?
    By dspratley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2006, 10:10 AM
  6. [SOLVED] Is there a macro or function to convert values to it written text
    By Dang Tran in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 06:20 PM
  7. [SOLVED] function to convert whole numbers to written text
    By Mani K in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2005, 06:10 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