S
SUB-ZERO
Hi,
RagDyeR, thanks for the prompt reply, but unfortunately it did not work, is this for Excel?
I have not seen a function quite like this in any excel spreadsheets. Of course I am no programmer tho.
RE: =IF(ISNA(LOOKUP(9.99999999999999E+307,D1
11)),D12,LOOKUP(9.99999999999999E+
307,D111)+D12)
This is another one in the same spreadsheet, does not have enough functions to complete my task at hand. What I am working on is a spreadsheet that keeps track of my hours driven and hours off duty for up to a total of 8 days, and if during any of the 8 days I show having taken off more than 33 hrs, I regain my 70 hrs available to drive for that week.
=IF(C20>33,D20,IF(C19>33,SUM(D1920),IF(C18>33,SUM(D1820),IF(C17>33,SUM(D1720),IF(C16>33,SUM(D1620),IF(C15>33,SUM(D1520),IF(C14>33,SUM(D1420),SUM(D1320))))))))
Okay, say day 8 is the current date, it goes back from the current date only as far back as day 1. IF ... during any of the 8 days I show having taken more than 33 hrs off on day 5, then it only counts the hours from day five to day 8 and subtracts from 70 giving my total hours left for that week.
Im not asking for anyone to create the formula, I already have this formula that works, here's what Im looking for, is there something that I can do to shorten it to get the same result so that I may add to this formula. I wonder why Microsoft only allowed for 7 functions, why not 10 or Infinite?
Anyhow .. Thanks for any help on this matter.
SUB-ZERO
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
RagDyeR, thanks for the prompt reply, but unfortunately it did not work, is this for Excel?
I have not seen a function quite like this in any excel spreadsheets. Of course I am no programmer tho.
RE: =IF(ISNA(LOOKUP(9.99999999999999E+307,D1
11)),D12,LOOKUP(9.99999999999999E+307,D1
11)+D12)This is another one in the same spreadsheet, does not have enough functions to complete my task at hand. What I am working on is a spreadsheet that keeps track of my hours driven and hours off duty for up to a total of 8 days, and if during any of the 8 days I show having taken off more than 33 hrs, I regain my 70 hrs available to drive for that week.
=IF(C20>33,D20,IF(C19>33,SUM(D19
20),IF(C18>33,SUM(D1820),IF(C17>33,SUM(D1720),IF(C16>33,SUM(D1620),IF(C15>33,SUM(D1520),IF(C14>33,SUM(D1420),SUM(D1320))))))))Okay, say day 8 is the current date, it goes back from the current date only as far back as day 1. IF ... during any of the 8 days I show having taken more than 33 hrs off on day 5, then it only counts the hours from day five to day 8 and subtracts from 70 giving my total hours left for that week.
Im not asking for anyone to create the formula, I already have this formula that works, here's what Im looking for, is there something that I can do to shorten it to get the same result so that I may add to this formula. I wonder why Microsoft only allowed for 7 functions, why not 10 or Infinite?
Anyhow .. Thanks for any help on this matter.
SUB-ZERO
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-