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

CUSTOMER NAME: |  |  |  |  |  |  | TOTAL CONTRACT SERVICES |  |  |  | TOTAL CONTRACT VALUE |  |  |  |  | PAYMENT TYPE |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTRACT | YES | SERVICE | LAWN | GARDEN | ENHANCE | LABOUR COST | 28 | JANUARY | √ | MULCH | COST | INSTALLED | DELIVERED | 1
ADDRESS: |  |  |  |  |  |  | TOTAL EXTRA SERVICES |  |  |  | TOTAL [NAME] |  |  |  |  |  |  | FULL PAYMENT |  |  |  |  |  |  |  |  |  |  |  | EXTRA |  | LAWN | SPRING LAWN | SPRING GARDEN | LAWN FERTILIZER (Spring) | LABOUR CHARGE | 45 | FEBRUARY |  | UTILITY | 10 | 53 | 15 | 2
CITY / TOWN |  |  |  |  |  |  | TOTAL COMBINED SERVICES |  |  |  | TOTAL COMBINE VALUE |  |  |  |  |  |  | 2 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  | GARDEN | SUMMER LAWN | GARDEN CARE | LAWN FERTILIZER (Summer) | MAT. UPCHARGE | 1.5 | [NAME] |  | CANADA RED | 29.75 | 76 | 45 | 3
 |  |  |  |  |  |  |  |  |  |  | DISCOUNT |  | 0.15 |  |  |  |  | 3 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCE | FALL LAWN | FALL GARDEN | LAWN FERTILIZER (Fall) |  |  | APRIL |  | PIN O-NOIR | 31.25 | 78 | 47 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPOST TOPDRESS |  |  | MAY |  | BLACK BEAUTY | 29 | 93 | 44 | 5
 |  |  |  |  |  |  | SERVICE |  | TIME | ACTUAL |  |  |  |  |  |  |  | 5 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corn Gluten (Spring) |  |  | [NAME] |  | COMPOST | 17.5 | 50 | 27 | 6
SEASONAL LAWN SERVICES |  |  |  |  |  |  | TYPE | PRICE | ALLOTTED | TIME | NOTES |  |  |  |  |  |  | 6 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corn Gluten (Summer) |  |  | JULY |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 1 |  |  | AUGUST
SPRING LAWN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 EQUAL PAYMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 2 |  |  | SEPTEMBER
SUMMER LAWN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE MONTHLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 3 |  |  | OCTOBER
FALL LAWN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIESTA 4 |  |  | NOVEMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY REVENUE STATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DETHATCHING |  |  | DECEMBER
 |  |  |  |  |  |  | SERVICE |  | TIME | ACTUAL |  |  |  |  |  |  |  | LABOUR | MATERIAL | TOTAL | LABOUR | MATERIAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  | CORE AERATION
SEASONAL GARDEN SERVICES |  |  |  |  |  |  | TYPE | PRICE | ALLOTTED | TIME | NOTES |  |  |  |  | MONTH |  | COST | COST | COSTS | CHARGE | CHARGE | CHARGES | EVALUATION |  |  |  |  |  |  |  |  |  |  | SEASONAL PLANTING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Spring) GUTTERS
SPRING GARDEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Fall) GUTTERS
GARDEN CARE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEMATODES
FALL GARDEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (DRIVEWAY SPRAY)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POISON IVY SPRAY
 |  |  |  |  |  |  | SERVICE |  | ACTUAL | PRODUCT |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MULCH INSTALLED
LAWN & GARDEN ENHANCEMENTS |  |  |  |  |  |  | TYPE | PRICE | TIME | QUANTITY | NOTES |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MULCH DELIVERED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (1)
LAWN FERTILIZER (Spring) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (2)
LAWN FERTILIZER (Summer) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (3)
LAWN FERTILIZER (Fall) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENHANCEMENT (4)
COMPOST TOPDRESS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER
CORN GLUTEN (SPRING)
CORN GLUTEN (SUMMER) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SUMMARY
FIESTA 1
FIESTA 2
FIESTA 3
FIESTA 4
DETHATCHING
CORE AERATION
SEASONAL PLANTING
(SPRING) GUTTERS
(FALL) GUTTERS
NEMATODES
(DRIVEWAY SPRAY)
POISON IVY SPRAY
 |  |  |  |  |  |  |  | PRICE |  | YARDS | PRODUCT TYPE
MULCH INSTALLED
MULCH DELIVERED
 |  |  |  |  |  |  | SERVICE |  | ACTUAL | PRODUCT
ADDITIONAL ENHANCEMENTS |  |  |  |  |  |  | TYPE | PRICE | TIME | QUANTITY | NOTES
ENHANCEMENTS (1)
ENHANCEMENTS (2)
ENHANCEMENTS (3)
ENHANCEMENTS (4)
 |  |  |  |  | SERVICE |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  | LABOUR | MATERIAL | TOTAL | LABOUR | MATERIAL | TOTAL
MONTH |  | DATE |  |  | TYPE | SERVICE | SPECIFIC SERVICE |  |  | START | FINISH | PEOPLE | TIME | LITRES | KG'S | YARDS | NOTES |  |  |  | COST | COST | COST | CHARGE | CHARGE | CHARGE | INVOICED
 |  |  |  |  | CONTRACT