Excel Forum

Excel Name Trick #9: Create Name Formulas

See how to create name formulas that can be then used in cells.

1) See how to create a dynamic range using a named formula that uses the OFFSET function.
2) See how to create a named formula that will randomly create sales figures between an upper and lower value.
3) See how to store a tax rate constant in a name.

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).

Got a Question? Ask it Here in the Forum.