+ Reply to Thread
Results 1 to 5 of 5

extending an existing formula

  1. #1
    Registered User
    Join Date
    04-15-2010
    Location
    northampton
    MS-Off Ver
    Excel 97-2000
    Posts
    9

    extending an existing formula

    my existing formula for deducting a varible time from a range of times is
    =IF(K3>=J7,(IF(K3<=K7,(K7-J7-M3),0)),0) this works fine and if thre is no break to deduct in cell m3 it returns a 0 result ,however when i have tried to extend the cells to be evaluated the result returns as false ,this causes a problem as the cell is a total the formula i have tried is =IF(K3>=J7,(IF(K3<=K7,(IF(K4>=J8,(IF(K4<=K8,(K8-J8-M4),0)),0)))))
    any help would be appriecated

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: extending an existing formula

    Would it not be easier to perhaps re-write along the lines of:

    =IF(AND(K3>=J7,K3<=K7,K4>=J8,K4<=K8),K8-J8-M4,0)

  3. #3
    Registered User
    Join Date
    04-15-2010
    Location
    northampton
    MS-Off Ver
    Excel 97-2000
    Posts
    9

    Re: extending an existing formula

    the problem is k3/k4 and m3/m4 could be relevant to k7,j7 k8 j8 k9 j9 it depends when the driver decides to take his break so i must cover all possibilties

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: extending an existing formula

    Sorry, the above makes little sense to me - your initial post read along the lines of "use this formula without generating Boolean FALSE" - hence the suggestion.

    I would suggest you post a sample file which outlines both your setup and also some expected results based on values present (perhaps with a few variations thereof).

  5. #5
    Registered User
    Join Date
    04-15-2010
    Location
    northampton
    MS-Off Ver
    Excel 97-2000
    Posts
    9

    Re: extending an existing formula

    Thanks will have to do that later works system will not allow uploads thanks for the help thou

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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