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 ...

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.