Formula to display "Credit"

  • Hello,


    I am working on a project and need a little help. On my invoice template I need to enter a formula that will display the word "Credit" in cell J48 if there is a credit on the invoice. If there is no credit then nothing is displayed J48.



    I47 J47
    Total ($10.00)
    J48
    Credit



    I47 J47
    Total $10.00
    J48


    Thank you!