public ExcelRange WriteDifferenceFormula(string minuendAddress, string subtrahendAddress, string format = "#,##0.00 ")
{
var fmla = $"={minuendAddress} - {subtrahendAddress}";
var cell = CurrentCell.WriteFormula(fmla, format);
MoveToNextRow();
return(cell);
}
public ExcelRange WritePercentFormula(string numeratorAddress, string denominatorAddress, string format = "#,##0.00 % ")
{
var fmla = $"={numeratorAddress} / {denominatorAddress}";
var cell = CurrentCell.WriteFormula(fmla, format);
MoveToNextRow();
return(cell);
}