Spreadsheet: 546697d1510160030-max-formula-returning-a-result-of-0-for-cells-containing-if-formula-results-pto-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Aniversary | P Hours | V Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 Days | 8 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Year | 24 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 Years | 24 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 Years | 24 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 Years + | 24 | 160
 | Cary Over |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | June |  | July |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Hours Used |  | Aniversary
Employee | P | V | P-1 | V-1 | P-2 | V-2 | P-3 | V-3 | P-4 | V-4 | P-5 | V-5 | P-6 | V-6 | P-7 | V-7 | P-8 | V-8 | P-9 | V-9 | P-10 | V-10 | P-11 | V-11 | P-12 | V-12 | P3 | V3 | Hire Date | # Years | P2 | V2
 | 8 | 16 | 8 |  |  | 4 |  | 12 |  | 8 |  | 8 |  |  |  | 44 |  | 40 |  |  |  |  |  |  |  |  |  |  | 1979-02-13 00:00:00
 | 48 | 148 |  | 4 |  |  | 40 | 16 | 8 | 32 |  | 4 |  | 8 |  | 8 |  | 16 |  |  |  | 12 |  |  |  |  |  |  | 1984-06-18 00:00:00
 | 50 | 36 | 16 | 8 |  |  |  |  |  | 12 |  | 16 |  | 56 |  |  |  |  |  | 8 |  | 16 |  | 40 |  |  |  |  | 1985-02-26 00:00:00
 | 20 | 74 |  |  |  |  |  |  |  |  | 4 | 8 |  |  |  |  |  | 16 |  | 8 |  |  |  | 8 |  |  |  |  | 1993-08-23 00:00:00
 | 20 | 69 |  |  |  |  |  |  |  |  |  | 8 |  | 48 |  | 8 |  |  |  | 8 |  |  |  |  |  |  |  |  | 1996-02-12 00:00:00
 | 0 | 60 |  | 4 |  | 8 |  |  |  | 16 |  |  | 8 | 16 |  | 4 |  | 16 |  | 48 |  | 40 |  | 24 |  |  |  |  | 2004-06-01 00:00:00
 | 0 | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-06-14 00:00:00 |  | 0 | 24
 | 16 | 64 |  |  |  | 40 |  |  |  | 24 |  | 8 |  |  |  |  |  | 40 |  |  |  |  |  | 24 |  |  |  |  | 2006-05-04 00:00:00
 | 0 | 56 |  |  |  | 14 |  |  |  |  |  | 16 |  |  |  | 8 |  | 24 |  | 4 |  |  |  |  |  |  |  |  | 2008-05-27 00:00:00
 | 120 | 56 |  |  |  |  |  |  |  |  |  | 72 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2011-01-03 00:00:00
 | 70 | 0 | 4 |  |  |  |  |  |  |  | 4 |  |  | 16 |  | 36 |  | 20 |  |  |  |  |  |  |  |  |  |  | 2012-05-21 00:00:00
 | 44 | 4 |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  | 12 |  | 8 |  | 8 | 8 |  |  |  |  |  |  |  | 2012-05-21 00:00:00
 | 64 | 88 |  |  | 4 |  |  |  |  | 16 |  |  |  |  |  |  |  | 8 |  | 8 |  | 4 |  |  |  | 40 |  |  | 2013-04-22 00:00:00
 | 54 | 40 | 8 |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 2013-05-20 00:00:00
 | 4 | 16 |  | 16 | 4 |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  | 8 |  |  |  |  |  |  |  | 2014-06-16 00:00:00
 | 56 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 8 |  | 4 |  |  |  |  |  |  |  |  |  | 2014-08-18 00:00:00
 | 32 | 80 |  |  |  |  | 20 |  |  |  |  | 40 |  |  |  | 40 |  |  |  |  |  | 24 |  |  |  |  |  |  | 2015-01-01 00:00:00
 | 24 | 64 | 8 |  |  |  |  | 40 |  | 4 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 24 |  |  | 2015-08-17 00:00:00
 | 24 | 48 |  |  | 12 |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 |  | 8 |  |  |  |  |  | 32 |  |  |  |  | 2015-10-05 00:00:00
 | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 8 |  |  |  |  |  |  |  |  | 2016-02-08 00:00:00
 | 0 | 0 |  |  |  |  |  | 64 | 8 |  |  | 8 |  |  |  | 8 | 4 |  | 4 |  |  |  |  |  |  |  |  |  | 2016-03-07 00:00:00
 | 0 | 80 |  |  |  |  |  | 24 |  | 40 |  |  |  | 16 |  |  |  | 8 |  | 4 |  |  |  |  |  |  |  |  | 2016-04-04 00:00:00
 | 0 | 32 |  |  |  | 4 |  |  |  | 16 |  | 8 |  | 40 |  |  |  | 4 |  |  |  | 12 |  |  |  |  |  |  | 2016-05-16 00:00:00 |  |  | 120
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 32 |  |  |  |  |  | 40 |  |  | 2016-06-01 00:00:00
 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  |  | 2016-08-15 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-30 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-27 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-03-30 00:00:00
 | 8 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  | 4 | 16 | 4 |  |  |  |  |  |  |  | 2017-06-26 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-09-18 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-09-18 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-02 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-14 00:00:00
 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-02 00:00:00