macbookboy,
I'm not sure what you mean by "need the table to create a new section"
Attached is a modified version of your example workbook.
I inserted a new row (row 12), which contains this formula in cell E12:
=INT(CEILING(E4/B3,4)/128)+1
That formula shows the number of 32 Engines needed to accomadate the No. of SMS entered. So with the 500,000 SMS example, the formula returns the number 2.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Pricing Sheet - SIM CARDS (Modified by tigeravatar & macbookboy) (2).xlsxPricing Sheet - SIM CARDS.xlsxThat is fantastic tiger!!
just what i was looking for
What i mean by having a new "box" When 500,000 was input it gave 2 x 32 sims, now the 32 (is a product) shall we say in the case GSM Gateway 7000, i wanted it to take me to a box which would list product information in, so basically the whole point in the table is for our business to enter a value (SMS) and it will give us all the information in the box and (ideal) product what matches the figures ?
Again thanks for the help, if you can help further that would be great, I am a very novice user
I have uploaded just the desgin, but i am not sure how to link it, see the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
macbookboy 
Register To Reply
Bookmarks