Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA

Learn about how to Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA.
Topics in Video:
1. (00:11) Introduction
2. (01:19) FORMULATEXT & ISFORMULA & IF Functions to create formula to show formula in cell
3. (02:50) Average Formula using SUMPRODUCT and COUNT so we can calculate average of Units and Price columns
4. (03:57) Standard Deviation using Helper Column, using the STDEV.P Function.
5. (04:27) Array Formula for calculating Standard Deviation from Price and Units Columns using STDEV.P Function and the keystroke Ctrl + Shift + Enter

[LeilaGharani]

Love it! and you didn't just show FormulaText, you showed it with great examples. Thank you.

[leocorreia]

When building financial models, I've found that the layout from raw data to reporting systems is critical. The design needs to have a clear audit trail. FORMULATEXT & ISFORMULA are powerful tools in building this audit trail. Thanks for the video.

[SyedMuzammilMahasanShahi]

Wow. Yet another EXCELlent video Mike. That is beautiful, brilliant man. Thumbs up!!!

[amitkumar-ipyv]

Mike, I cannot resist going through your video even in the middle of my hectic MBA course.really awesome tips.

[komanguy]

Thanks a lot. Just bought your ebook (Crtl+Shift+Enter Mastering Excel Array Formulas) on Amazon to go deeper.

[krn]

Thanks Mike. I still use Excel 2010 at work so I had to create a UDF to show my formulas. Pretty easy to do of course. Function FT(MyCell as range) ^CR FT = MyCell.Formula^CR End Function. Now I just need to enter =IF(ISFORMULA(A2), FT(A2), "")

[basudevbasak]

Mike, your videos are just awesome. Can't thank you enough.

[johnborg]

Thanks again Mike. Always on the lookout for new Formula Videos from you. :)

[JeremyMcMahan]

Awesome video. I didn't know about the ability to show the formula!

[chuckhamdan]

I really love your Video clips, excellent and very useful to all Excel users. Keep up the good work. All the best to everyone!

[Pegasus]

Very helpful. As always, thank you very much!!!

[AlphaH]

I would say that was outstanding 👏🏻👏🏻👏🏻👏🏻👏🏻

[petevichy]

Even though I use version 2010, I've still enjoyed your tricks in this VDO. Thanks Mike :-)

[barttitulaerexcelbart]

Well Mike, I think this video deserves a golden edge!! I think I will use this formula from now on very often.
As a lecturer in class, how often was I requested to put the cursor on a cell with a complex formula. This is a real timesaver! Also for the students in the back rows, who find it difficult to read the formula bar. Windows-+ (scope) is not so good. Mike can you add a video how to put this formula in all new worksbooks with a button? So in a default template? Thank you so much!

[sandipghara]

NICE VIDEO can i do reverse process?? pls answer me

[ikark]

Great trick Mike! Thanks! Does it work in regular excel 2016?

[XeeshanAhmad]

You are awesome man.. cant think, how to say thank you.
Will you please do me a tiny favor by making a video of debit credit running balance formula.

I will be much obliged

[jaehyi]

The fun never stops here! :)  Would there be any difference if I enclosed FORMULATEXT in IFERROR formula to show zero-length string when a formula is not present,  as below? =IFERROR(FORMULATEXT(A1), "")

[RobMichaels]

Do you know about CTRL ~ (tilda) which will show all the cell formulas instead of values (CTRL~ again toggles it off)? I recently discovered it. Thanks for another great video.

[cristianpopa]

The formulas aren't available in Excel 2010 ? Btw...amazing work !