Excel show formulas WITH NUMBERS
[Closed]
Report
ElWapp

rizvisa1
rizvisa1
 Posts
 4476
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 August 2, 2020
Related:
 Excel show formulas WITH NUMBERS
 Excel @ in formula ✓  Forum  Excel
 How to copy data from one sheet to another in excel using formula  HowTo  Excel
 How To Copy Data from One Excel Sheet to Another Using a Formula  HowTo  Excel
 Excel position formula ✓  Forum  Office Software
 Excel missing formula bar  HowTo  Excel
1 reply
rizvisa1
 Posts
 4476
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 August 2, 2020
For that you have to write a custom function first. Then use that function on your sheet
1. Open workbook
2. Press Alt + F11
3. Click on insert and add a new module
4. paste the code below the instructions
5. Call the function on sheet as given in the sample call
1. Open workbook
2. Press Alt + F11
3. Click on insert and add a new module
4. paste the code below the instructions
5. Call the function on sheet as given in the sample call
'This functions returns the formula written in a cell 'if more than once cell is passed as parameter, it will return **Error** 'formulaCell : cell which as the formula ' Sample Call : =displayFormula(c1) Public Function displayFormula(formulaCell As Range) As String Dim result As String If formulaCell.Count <> 1 _ Then result = "**Error**" Else result = formulaCell.Formula End If displayFormula = result End Function
Report
ElWapp
Thanks, but this is not exactly what I need... Your function shows the general formula, but I would like to see the numbers used in calculation (Instead of "=A4+B4" to show "=28+45", where A4=28 and B4=45).
Report
rizvisa1
 Posts
 4476
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 August 2, 2020
For that you can try using evaluate function. However it will be not be easy to write value. Basically in that you have to write "=28+45" this part yourself, evaluate can solve and tell u what this value is