=IF(H5="y",0,IF(C5=0,0,IF((G5+F5)-E5<0,0,(G5+F5)-E5)))
H5 is "Fee waived" and the input is either "y" or "n"
C5 is "Date Notice Sent"
G5 is "CP Fee"
F5 is "PVPO Fee"
E5 is "Amount Received"
Overall this gives the amount still owed, I just want to understand HOW exactly that's calculated and I'm not fluent in Excel!
Bookmarks