Spreadsheet: 453489d1459343179-cannot-get-isna-to-work-in-formula-test-2016
Sheet: example 1

2016 (LAWN & GARDEN)
CUSTOMER NAME: |  |  |  |  |  | CUSTOMER NOTES |  |  |  |  |  |  |  |  |  | TOTAL CONTRACT SERVICES |  |  |  |  | TOTAL CONTRACT VALUE |  |  |  |  |  |  |  |  |  |  |  |  |  | YES | Canada Red | JANUARY |  |  |  |  | 1 | X
STREET ADDRESS: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EXTRA SERVICES |  |  |  |  | TOTAL EXTRA VALUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pine O-Noir | FEBRUARY | LAWN | SPRING LAWN SERVICE | GARDEN CLEAN UP (SPRING) | LAWN FERTILIZER (SPRING) | 2
TOWN/CITY: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL COMBINED SERVICES |  |  |  |  | TOTAL COMBINED VALUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black | [NAME] | GARDEN | SUMMER LAWN SERVICE | GARDEN CARE | LAWN FERTILIZER (SUMMER) | 3
PHONE NUMBER: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNT IF APPLICABLE |  |  | 0.015 |  |  |  |  |  |  |  |  |  |  |  | Utility | APRIL | ENHANCEMENTS | FALL LAWN SERVICE | GARDEN CLEAN UP (FALL) | LAWN FERTILIZER (FALL) | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  | COMPOST TOPDRESS | 5
SEASONAL LAWN SERVICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAYMENT TYPE |  |  |  |  |  |  | NOTES |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | CORN GLUTEN (SPRING) | 6
 |  |  |  |  |  |  | Contract | Extra | Price $$ | Scheduled Time |  | Actual Time |  | Difference |  | NOTES |  |  |  |  |  | FULL PAYMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY |  |  |  | CORN GLUTEN (SUMMER)
SPRING SERVICE (Bi-Weekly visits to prepare lawn for summer service) |  |  |  |  |  |  |  | YES | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 2 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  | BROADLEAF WEED SPRAY (1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER |  |  |  | BROADLEAF WEED SPRAY (2)
SUMMER SERVICE (Mowing & trimming) |  |  |  |  |  |  |  | YES | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 4 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  | BROADLEAF WEED SPRAY (3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  | BROADLEAF WEED SPRAY (4)
FALL SERVICE (Weekly inspection of property. Collect leaves & disposal) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER |  |  |  | DETHATCH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORE AERATION
SEASONAL GARDEN SERVICE |  |  |  |  |  |  | Contract | Extra | Price $$ | Scheduled Time |  | Actual Time |  | Difference |  | NOTES |  |  |  |  |  | 8 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEASONAL PLANTING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE MONTHLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MULCH GARDEN
GARDEN CLEAN UP (Spring pruning-Removal of weeds and debris) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GUTTERS (Spring)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY REVENUE STATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GUTTERS (Fall)
GARDEN CARE (Weeding, edging, trimming of hedges & shrubs) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR | MATERIAL | TOTAL | LABOUR | MATERIAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEMATODES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH |  | COST | COST | COSTS | CHARGE | CHARGE | CHARGES |  |  |  |  |  |  |  |  |  |  |  |  |  | DRIVEWAY SPRAY
GARDEN CLEAN UP (Pruning of shrubs and cutting back perennials) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POISON IVY SPRAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (1)
LAWN & GARDEN ENHANCEMENTS |  |  |  |  |  |  | Contract | Extra | Price $$ | Scheduled Time |  | Actual Time |  |  | TOTAL TIME | Product Quantity |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (2)
 |  |  |  |  |  |  |  |  |  |  |  | Spring | Summer | Fall |  | Spring | Summer | Fall |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (3)
LAWN FERTILIZER (Spring, Summer, Fall) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilogram | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
COMPOST TOPDRESS with [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilograms |  | JULY
 |  |  |  |  |  |  |  |  |  |  |  | Spring | Summer |  |  | Spring | Summer |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR COST | 29
CRAB GRASS PREVENTION (Spring & Summer) Corn Gluten |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilograms |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR CHARGE | 45
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  | OCTOBER
BROADLEAF WEED SPRAY (1) (2) (3) (4) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Time |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATERIAL UP CHG. | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total in Litres |  |  | DECEMBER
DETHATCHING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SUMMARY
CORE AERATION OF LAWN
SEASONAL PLANTING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Type
MULCH GARDENS
 |  |  |  |  |  |  |  |  |  |  |  | Spring | Fall |  |  | Yards
GUTTER CLEANING (Spring & Fall)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Type
NEMATODES
[NAME] (DRIVEWAY SPRAY)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Litres Mixed
POISON IVY SPRAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Litres Mixed
ADDITIONAL ENHANCEMENTS
 |  |  |  |  |  |  | Contract | Extra | Price $$ | Scheduled Time |  | Actual Time |  | Difference
ENHANCEMENTS (1)
ENHANCEMENTS (2)
ENHANCEMENTS (3)
ENHANCEMENTS (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR | MATERIAL | TOTAL | LABOUR | MATERIAL | TOTAL | PROFIT/
MONTH |  | DATE |  |  |  | CONTRACT | EXTRA | SERVICE |  | SUB SERVICE |  |  |  | START | FINISH | PEOPLE | TOTAL TIME |  | LITRES | KILOGRAMS | YARDS | NOTES |  |  |  |  | COST | COST | COST | CHARGE | CHARGE | CHARGES | LOSS | INVOICED