Results 1 to 4 of 4

Thread: SUMPRODUCT function =MIN?

  1. #1
    Neophyte hackertom's Avatar
    Join Date
    Sep 2018
    Posts
    3
    Articles
    0
    Excel Version
    2016

    SUMPRODUCT function =MIN?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want some help in my file, if user add 5 or 6 then he adds hours in cell Night Work Hours, i want to count max to 48.

    If user add D in cell Hollidays then remove by -1 ... i want to remove from 48, e.g 47 46 45 44 43 ..... 0.

    and if user add R then remove by -1 in cell Day Off... i want if add R on holidays table days then count +1
    Attached Files Attached Files

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,504
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Link added by OP
    Last edited by Pecoflyer; 2018-09-14 at 12:06 PM.
    Thank you Ken for this secure forum.

  3. #3

  4. #4
    Neophyte hackertom's Avatar
    Join Date
    Sep 2018
    Posts
    3
    Articles
    0
    Excel Version
    2016
    https://www.mrexcel.com/forum/excel-...n-numbers.html

    i use 3 forums, but this is not the same question...

Posting Permissions

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