Solved

Excel Formula in one sell and Result in another

Posted on 2011-02-17
5
430 Views
Last Modified: 2012-06-27
EE Professionals,

How do I put a formula that can be reviewed in one sell with the result being shown in another (next to it).  In other words, I want to formulate "the math" in one cell where is shows the actual formula and then show the result in another.  I do not want to have to use the ' symbol to show no calc.

Example:  
A                                 B
(5*6)*12+500            410

A sample would be much appreciated.

Thank you,

B.


0
Comment
Question by:Bright01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 8

Assisted Solution

by:ragnarok89
ragnarok89 earned 400 total points
ID: 34922398
Create a custom function/formula, and then use it.

Function GetFormula(Cell as Range) as String
   GetFormula = Cell.Formula
End Function

Usage: Examples using GetFormula
  =GetFormula(A1)                        -- Display the formula used in cell A1
0
 

Author Comment

by:Bright01
ID: 34923925
Ragnarok89,

Sorry to be confused but how do I create a custom function/formula?  Can you provide a quick sample?

Thanks,

B.
0
 

Author Comment

by:Bright01
ID: 35005721
Ragnarok89,  I gave this a try in a blank spreadsheet; but I can't get it to work right.  Can you send a small quick sample?

Thank you,

B.
0
 
LVL 58

Accepted Solution

by:
tigermatt earned 100 total points
ID: 35043844

No points for me please, because this is simply an example of the work from ragnarok09.

See the attached spreadsheet for an example of this in practice. Like your last question, it involves the use of VBA programming, as do lots of things of "advanced" nature in Excel and other Office suite applications.

-Matt
ShowFormulaInCellExample.xls
0
 

Author Closing Comment

by:Bright01
ID: 35044758
Too late!  You gave me the example that made it easy to use.  I awarded Ragnarok 400 Points, but your solution made it actually usable.

Thanks,

B.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Converting Excel to OFX 2 130
Microsoft Dynamics CRM user does not trigger email when closing as won 4 58
SignTool Error with Windows 10 5 218
Doc'in system (example?) BA 7 120
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question