Excel Function

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
LVL 4
Moizsaif123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mark_harris231Commented:
Moizsaif - I'm afraid I couldn't follow the logic /figure out what you need the function to do.  It might help if you could manually mock up what you want it to look like and we can 'reverse-engineer' from there.

Mark
0
Moizsaif123Author Commented:
sorry for the late reply, all i want is for the function to return how many systems    to return.

So if number of extension is say 5 then according to math above each system has 4 slots and each slot has 8 extensions so the function returns 1 sytem

another example if customer need 33 extension then the return would be 2 systems.

Please let me know if im not clear

0
mark_harris231Commented:
Still not sure I'm fully following the logic, but if it's as simple as 1 system = 32 extensions, then the following should work for 'x' extensions:

=ROUNDUP(E43/32,0)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.