Ampler cycles the selected cells through your company’s standard formats for multiples (such as 8.5x) in a keystroke, so numbers are formatted consistently across a model.
Quick answer: Select the cells and click Cycle multiple format on the Ampler ribbon; click again to cycle to the next format.
How to use it
Select the cells, then cycle the format.
- Select the cells you wish to format.
- Click Cycle multiple format, and click again to cycle to the next format.
The formats it cycles through are the ones defined under Settings → Cycles, so you can set them to your company standards.
Why use it
Valuation and operating multiples — 8.5x, 12.0x — have a house format, and setting it by hand each time is inconsistent. Ampler cycles through the standard multiple formats in a click.
How consultants use it
Consistent number formatting is a basic quality signal in a model, and applying a house standard by hand is slow. Three habits apply:
- A consistent multiple format: every multiple reads the same, e.g. one decimal and an ‘x’
- Fast on valuation work: multiples are formatted in a keystroke
- On the house standard: the format comes from the defined cycle
Cycling the multiple format keeps valuation figures consistent.
Tips & best practices
- Select a range and cycle to the standard format.
- Set the formats to your house standard under Settings → Cycles.
- Keep formatting consistent across the whole model.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you format a valuation multiple in Excel?
Select the cells and click Cycle multiple format on the Ampler ribbon to apply your standard multiple format (such as 8.5x).
Where is the multiple format defined?
Under Settings → Cycles, so it matches your company standard.