I’m brand new to Airtable and am loving it so far. I have a product which has tiered pricing based on the volume of licenses that are purchased. Example 1-4 = $75, 5-10= $50, 11-24 = $55. There are 14 tiers. I want to enter the exact number of licenses that are being purchased, identify the category that belongs to, display the per price cost and then calculate the total license fees for # Licenses * Cost per License. Any help is appreciated.
I also have other types of fees which I can manually enter as they are simple, but I’d also like to add the license fees plus the other fees to give me the total amount to be billed. Possible?