CPA PEP Prep Q&A

Excel formula

 
Picture of Hamid Behmanesh
Excel formula
by Hamid Behmanesh Send a message - 30 Jul 2020, 4:02 PM
 

Hi guys. As you all know it is recommended to show your formula in excel and there are few ways to do it. One is copy and pasting every cell that contains formula into another cell and just put apostrophe in front of the formula. This is time consuming.

Other way is to click on show formula but this shows the entire sheet as formula not specific cell as formula.

Please advise if there is another method? 

Picture of Celine Lambino
Re: Excel formula
by Celine Lambino Send a message - 19 Aug 2020, 4:05 AM
 

Hi Hamid,

Beside the cell that contains the formula, you may use the excel formula =formulatext(A1). This will show the formula/content of the cell reference.

Hope this helps.

Kind regards,

Celine