In the above example, four cells are written out. The first two have text hard- coded. The second two have variables. The third and fourth items have another thing that should be noted. If you have text where you want a variable in the middle, you have to use the latter form. Variables within parameters are the entire parameter's value.

Please see Spreadsheet::WriteExcel for what constitutes a legal formula.