Finding formulas

  • Thread starter Thread starter S. Jones
  • Start date Start date
S

S. Jones

If I have a spreadsheet with employee names, a list of 9 products with
objectives and actual number achieved, and I want to find the formula on the
sheet that was used to get an overall percentage, how do I find the
formula??
 
An excellent way to determine where information is coming from is the
Auditing Tool Bar. Right Click in the Tool Bar Area, Select, Customize, The
check the Auditing Tool Bar.

Using the Trace Precedents and Trace Dependents will show where the
information originates and then where it goes. Note: Click each as many
times as necessary
 
Back
Top