Overview

What is Formula Indenter?

· Formula Indenter is an add-in designed for Microsoft Excel that copies formulae from the selected cells to the clipboard and indents them to improve and speed up understandability of the formulae.

· Once the formulae has been pasted in to a word processor the indentation makes it much easier to understand formulae that are non trivial since the indentation allows you to quickly identify which arguments in the formulae relate to which logic branches in the formulae.

· The Formula Indenter has been designed as a tool to aid model review by providing a mechanism to understand and document non trivial formulae.

How to use the Formula Indenter

1. Select the cell(s) in the active worksheet you want to be reported.

2. Select the “Indent Formulae…” item from the tools menu.

3. The formulae have now been copied to the Windows clipboard and indented, the next step is to paste them in to a word processor such as Microsoft Word where the indented formulae can be printed off and annotated\cross referenced as appropriate.

Example

A cell formula displayed in the Excel formula bar:

The cell formula once it has been copied to the clipboard and ‘indented’:

Example.xls John Mote

12/08/2005 19:04:27

_________________________________________________________

sysTimeline!H16

=IF

(

H20=$C21

,sysForecastStart

,IF

(

H20>$C21

,G17

+1

,DATE

(

YEAR(I16)

,MONTH(I16)

-12

/OFFSET

(

$F13

,MATCH(H14,$D14:$D16,FALSE)

,0

)

,DAY(sysForecastStart)

)

)

)