I am currently using the below formula to calculate enablement costs for meters
This worked fine as the fee of $5500 was standard, however I now need to incorporate a new cost for a specific meter. The NZ meter is $13000. In column F the classification is NZ Instant Reserve.
How do I maintain the above formula for the rest of my spreadsheet, but add the additional IF check for the specific meter (which only account for about 10% of my whole list).