VLOOKUP and IF and PMT.xlsx - Health Fitness Gym Date...

This preview shows page 1 - 2 out of 2 pages.

HicksNew Clients01bfb43de238db541eec11a65154c33cec2e84d1.xlsxHealth & Fitness GymDate Prepared:8/14/2019ClientMembershipCostLockerAnnual TotalYearsTotal DueBalanceAndrewsDeluxe575 Yes$ 650.00 1$ 650.00 $ 250.00 $ 400.00 BakerIndividual300 Yes$ 375.00 2$ 750.00 $ 150.00 $ 600.00 CarterFamily1500 No$ 1,500.00 3$ 4,500.00 $ 700.00 $ 3,800.00 DudleyDeluxe575 No$ 575.00 2$ 1,150.00 $ 250.00 $ 900.00 EvansDeluxe575 Yes$ 650.00 3$ 1,950.00 $ 250.00 $ 1,700.00 FoustIndividual300 No$ 300.00 1$ 300.00 $ 150.00 $ 150.00 GardnerIndividual300 No$ 300.00 2$ 600.00 $ 150.00 $ 450.00 HartIndividual300 No$ 300.00 3$ 900.00 $ 150.00 $

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture