I appreciate someone who can help me on my formula in Late Charges and Amount Due
Late charges should only compute once today's date > grace period. If there is payment made before grace period, late charges = 0.
Tota Due = Payment due + Prev Balance + Late Charges
Thank You
In E6, =IF([@[Date Paid]]>[@[Grace Period]],10,"-")
In F6, =SUM($G$1,[@[Late Charges]])
Please find
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks