+ Reply to Thread
Results 1 to 2 of 2

Late Coming Calculations

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Late Coming Calculations

    Hello
    I am trying to compute deduction to be made for latecoming of employees

    attached sample
    4 late comings are allowed as shown in B2
    In excess of 4, it is calculated for every 4 and part there of
    So in total 13, 4 exempted that is 13-4=9
    so now this 9 spilt in multiples of 4 is 4,4 and 1
    So first 4 is 100*4, next 4 is 200*4 and remaining 1 is 400*1
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: Late Coming Calculations

    Try,
    D2=MIN(C2,4)*100
    E2=MIN(C2-MIN(C2,4),4)*200
    F2=MAX(C2-8,0)*400

+ 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. Replies: 2
    Last Post: 08-22-2022, 06:16 PM
  2. Late Coming Calculation
    By grcshekar in forum Excel General
    Replies: 3
    Last Post: 02-06-2021, 03:00 AM
  3. Average calculations coming out slightly too high
    By dave180 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-12-2018, 08:20 AM
  4. Replies: 6
    Last Post: 07-19-2017, 12:20 AM
  5. [SOLVED] Entered inside zone and coming outside values calculations
    By thilag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2014, 04:52 AM
  6. Values not coming in few cell but coming in rest all cells
    By rashmib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 11:19 AM
  7. Late Binding or Late Anything
    By Piranha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2005, 10:42 PM

Tags for this Thread

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