+ Reply to Thread
Results 1 to 1 of 1

late fee calculator

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    28

    late fee calculator

    hi friends,
    i am creating a late fee calculator for which rules are as follows.
    1.late fee will be calculated @Rs2/day but maximum fine for a month will be Rs. 50/month
    2. month of august will have 2 and month relaxation and september will have 1 month relaxation.
    3.session will start from august and will end in july.
    4.no fine can be calculated after current month
    5.fine will also not be calculated for the months for which fee has been already deposited.
    6. the total amount must be in the multiple of 5 rounding in a manner such that 2 and 4 will be 0 and 6 and 8 will be 5.
    although i have achieved this but i had to create many columns which looks to be ridiculous.
    plz help me to convert this into a smarter worksheet.
    the excel file is attached for your convenience to understad the rules.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Day late
    By mai07 in forum Excel General
    Replies: 0
    Last Post: 02-29-2016, 11:37 AM
  2. A little late - Hi!
    By dmersinger in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-23-2013, 10:13 AM
  3. Better late than never or ??
    By Alf in forum The Water Cooler
    Replies: 8
    Last Post: 08-01-2013, 08:47 PM
  4. Late Binding
    By energizek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2009, 03:41 AM
  5. [SOLVED] Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM
  6. Late Binding or Late Anything
    By Piranha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2005, 10:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1