M
Mike
What do you mean? Do you want X to be a variable to use
in other worksheet functions, or are you trying to use
Roman numerals?
To assign X as a variable, you can use a named range. For
example, select cell A1. In the Name box (to the right of
the formula bar), enter X. Now anything you enter in cell
A1 will be assigned to the variable. In any other cell
enter =X, and it will return whatever is in cell A1. Use
it in another function, for example, =X*5 will return 50.
To use Roman numerals, use the Roman() function. For
example, this will return 10 as an X.
=ROMAN(10,0)
in other worksheet functions, or are you trying to use
Roman numerals?
To assign X as a variable, you can use a named range. For
example, select cell A1. In the Name box (to the right of
the formula bar), enter X. Now anything you enter in cell
A1 will be assigned to the variable. In any other cell
enter =X, and it will return whatever is in cell A1. Use
it in another function, for example, =X*5 will return 50.
To use Roman numerals, use the Roman() function. For
example, this will return 10 as an X.
=ROMAN(10,0)