+ Reply to Thread
Results 1 to 3 of 3

print cell formula values step by step

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    australia
    MS-Off Ver
    Excel 2016
    Posts
    15

    print cell formula values step by step

    Hello,

    I hope someone can help me.
    I need to print the step by step values of a formula in a cell

    for example lets say: cells(A,3)= Cells (A,1) + Cells (A,2)
    If cells(A,1) = 5 and Cells(A,2) = 3
    I need to print in Cells(A,3) :"=5+3=8"

    I know this is possible but i dont know how

    Thanks

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: print cell formula values step by step

    ="=" & a1 & "+" & a2 & "=" & a1+a2

    hth
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    05-26-2010
    Location
    australia
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: print cell formula values step by step

    Much appreciated Charlie

    it works nice and easy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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