To Calculate the Late Fee

[agrissy]

Hello,

Here is a link to an image of the spreadsheet: https://agrissy92.files.wordpress.com/2018/09/excel.png.

I tried this formula, =IFERROR([@[Amount]]-[@[Total Paid]]+[@[Late Fee]], "") but it did not work at all.

I also tried this formula, =IF(F8>0,F8-I8,"") it works but it would show $-32.75 instead of $32.75. I also tried on K10 (=IF(F10>0,F10-I10,"") but it shows "-" as it should show $17.50 and the status should state Partly Paid on M10.

I am sure this is a simple solution, but I could not figure it out. I am hoping that one of you could give me a better formula.

Thanks in advance!

 

[JackDanIce]

Welcome to the board.

Not seen the spreadsheet, but try adapting

=ABS(A1-B1)

 

[agrissy]

Thanks! It worked.

 

[JackDanIce]

You're welcome