Program to explain excel formula?

[JustJohn91]

Hi Everyone,

I have been tasked with explaining what every formula, in every spreadsheet, used in my organisation does. I am looking at having to explain hundreds of thousands of formula.

Does anyone know of a program that will explain formula in any format? An example of what i'm looking for is below. It doesn't have to exactly match the sample. Anything to help is greatly appreciated.

Thanks,
John

Formula:

=IF(J90>=J83,J84,H81)

Explanation:

If the value of Cell J90 is greater than or equal to the value of Cell J83 return the value of Cell J84. If the value of Cell J90 is not greater than or equal to the value of Cell J83 return the value of Cell H81.

 

[Joe4]

Try and work out roughly how many different formulas you use, divide it by 2 as I assume that you are one of the higher users then multiply that by the number of formula writers in your organisation.

Once you have that number write out the explanation for 10 of your formulas (time how long it takes to write the explanations and then divide it by 10).

Multiply the 2 resulting answers together, convert to hours and present that to the powers that be as your predicted man hours to carry out the task.

Then let them decide if they really want you to spend that amount of time on this task.

Yes, when they see how much time and money they will have to commit to pay you to complete this, let's see how "gung ho" they are on having you do this!