# of Functions per cell >> More

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:D11)),D12,LOOKUP(9.99999999999999E+
307,D1:D11)+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:D20),IF(C18>33,SUM(D18:D20),IF(C17>33,SUM(D17:D20),IF(C16>33,SUM(D16:D20),IF(C15>33,SUM(D15:D20),IF(C14>33,SUM(D14:D20),SUM(D13:D20))))))))

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/ =-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top