I am trying to build a program or function in excel for an invoice for a pabx system.
the system contains 48 trunk lines and 128 extensions.
These trunk lines are divided into 3 systems and each system contains 16 lines so therefore total is 48.
so if customer requires 18 trunk lines then the functions should prompt me 2 systems for customer and the cost for it.Ofcourse this is an example, I want it to work for "X" amount of
Similarly the number of systems are dependent on how many extensions the customer needs. Each system has 32 extension and there are 4 not 3 systems unlike the trunk lines. Total is 128 Extensions since 4 systems and
32 * 4 =128
so if customer needs "X" amount of extensions then the number of systems should be my return.
Then if customer require