Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP?
See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale:
1. VBA with Case
2. Nested IF function formula
3. VLOOKUP formula with three VLLOKUPs in one formula
4. VBA with simplier Case