Solved

Excel Formula in one sell and Result in another

Posted on 2011-02-17
5
393 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
  • 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now