Forum Discussion
dabadger
Jun 15, 2022Copper Contributor
Setting up Tiered Billing System
Calling All Excel Experts! I'm seeking help with setting up formulas for our small volunteer-run water company in drought-stricken CA, where we still have some water 'superusers'. I want to establish...
Riny_van_Eekelen
Jun 17, 2022Platinum Contributor
dabadger Begin by creating a table with the billing tiers as in the picture below. Then the formula in H2 will calculate the surcharge. file attached.