Show a negative balance

[Bedford]

Looking for a formula that will return a value that shows a negative (-) when a balance is due. The formula I’m using is simple, but not effective in showing a negative balance; =E21-F21-I21.

Total invoice amount is in column “E”, deposit received in column “F”, final payment in column “I” which is balance after deposit received, and balance owing in column “K” shows the status on the invoice. If the balance of the invoice is either zero or an overpayment of either the deposit amount or final payment I'm looking to have it show a negative with a minus sign, and if I could have it show in red text, even better.
Any help would be appreciated.
Thank you.

 

[Tivakaran]

I think the formula is right, if final payment is above inv amount, then it should show negative...about the red text, right click the cell, go to accounting & chose the red text

 

[Bedford]

I think the formula is right, if final payment is above inv amount, then it should show negative...about the red text, right click the cell, go to accounting & chose the red text

Hi Tivakaran, thank you for the response, you're correct, I was hoping to see a minus sign in "K" if the account had outstanding balance, but, simply showing a balance void of the minus symbol is adequate as well.
Happy Holidays!