You can also opt for the XOR function ... because I wanted Excel to work out whether cell B2 was blank, and either return "Data required" (if B2 was blank) or multiply the value in B2 by seven ...

There are two other methods to use the IMPOWER function in Excel. Method one is to click the fx button on the top left of the excel worksheet. An Insert Function dialog box will appear.

The Syntax for the ROMAN function. Open Microsoft Excel. Create a table. In the cell where you want to place the result type =ROMAN(A2). A2 is the cell that contains the arabic numeral.