Excel formula

Giganews Newsgroups
Subject: Excel formula
Posted by:  Vbel (vbelcou…@hotmail.com)
Date: 22 Jan 2007

I need help with a formula in Excel. It is a timesheet that totals the
hours.  An employee is allowed to work a max of 7 days or 70 hours, in
which case it sets back to 0, otherwise total.  I am trying to use a
nested IF formula but can't get all the arguments to work with each
other:

Sample data
    A  B
1  10  10
2  10  20
3  10  30
4  10  40
5  10  50
6  10  60
7  10  70

      =IF B7<>70,SUM(A1:A7),"0"
          IF A1=0, SUM(A2:A7)
          IF A2=0, SUM(A3:A7)
          IF A3=0, SUM(A4:A7)
          IF A4=0, SUM(A5:A7)
          IF A5=0, SUM(A6:A7)
          IF A6=0, A7

Any help would be appreciated.

Replies