If statement which references a cell and uses text if condition is true

[s2dks]

Hello,

I am trying to automate a footnote for a report. Here are the conditions:

If cell O13 does not equal 1, I want cell B39 to display the following text (including asterisk): **O13 denials are included in the table below.
Where the value of O13 is displayed.

If cell O13=1, I want cell B39 to display the following text (including asterisk): **1 denial is included in the table below.

I think a macros would be best but I have never written one before.

Currently I use this in cell B39: =CONCATENATE("** ",O13, " denials are included in table below as Intentional Program Violation in Sanction Reasons")
But that requires that every month I change "denial" to "denials" and "is" to "are" or vice versa.

TIA

 

[Crystalyzer]

Place this formula in B39

=IF(O13>1,"**" & O13 & " denials are ","**" & O13 & " denial is ") & "included in the table below."

 

[s2dks]

Thank you!!!!