How to Set Up an Ordinal Variable in Excel. An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd." ...

In the Set Cell field, select the cell that contains your total sales (e.g., A5). In the To Value field, enter your target value, which in this case is 250,000.