HoldMyTwist

Search HoldMyTwist

Calculate whole packs in Make with ceil

Calculate enough whole packs in Make with ceil. Follow a Free-plan example, compare round and floor, and check exact multiples and zero before using the result.

HoldMyTwist · 4 min read

Two full packs of six tokens and a third pack containing one token

When items must fit into whole packs, rounding to the nearest integer can leave you short. Make's ceil function (opens in a new tab) rounds the pack count up whenever there is a remainder.

This example uses 13 fictional items and packs of six. We ran it in Make Free with built-in Tools modules, without connecting an app or sending an order. If you only need one calculation, a calculator is simpler. This is useful when quantities already pass through a repeated Make workflow.

Before you start

You need a Make Free account and a browser. You will calculate three packs for 13 items, then check an exact multiple and zero. No external app connection is needed. Use an existing Make account, or create a Make account (opens in a new tab). Check the current Free plan limits (opens in a new tab) before building a larger workflow.

1. Enter the quantity and pack size

  1. Create a blank scenario and name it Whole packs practice. Keep its switch Inactive.
  2. Click the large plus, choose Tools, then Set variables.
  3. Set the first Variable name to items_needed and its Variable value to 13.
  4. Click Add variable. Name the second variable pack_size and set its value to 6. Click the module's Save.

Use nonnegative whole numbers for the item quantity and a positive whole number for the pack size. A pack size of zero cannot be used as a divisor. These variables are temporary data for this scenario run, as described in Make's scenario-variable guide (opens in a new tab).

Choose Enlarge image below a screenshot, then Open full-size image, to read the full editor view.

Full Make editor showing items_needed set to 13 and pack_size set to 6

Full Make editor showing items_needed set to 13 and pack_size set to 6
Open full-size image

2. Calculate the number of whole packs

  1. Click the plus beside the first module and add another Tools > Set variables module.
  2. Name its first variable packs_needed.
  3. In Variable value, paste the formula below. It assumes your input module is numbered 1. Check that items_needed and pack_size become the mapped tokens from that module.
Text to copy

{{ceil(1.items_needed / 1.pack_size)}}

Division calculates the unrounded pack count. The ceil function selects the next whole number when necessary. For 13 divided by 6, the result is three packs. They provide capacity for 18 items.

For the comparison shown in our output screenshot, add two more variables in the same module. Name them nearest_integer and rounded_down, using these values respectively:

Text to copy

{{round(1.items_needed / 1.pack_size)}}

Text to copy

{{floor(1.items_needed / 1.pack_size)}}

Make's function guide (opens in a new tab) explains how to insert functions and mapped values through the mapping panel. Click the module's Save, then the scenario toolbar's Save.

Map both inputs inside ceil. The comparison variable uses round with the same division.

Full Make editor mapping items_needed divided by pack_size into ceil and round formulas

Full Make editor mapping items_needed divided by pack_size into ceil and round formulas

Map both inputs inside ceil. The comparison variable uses round with the same division.

Open full-size image

Watch out

Use ceil when every item needs a place in a whole pack. For 13 items, round and floor both return two packs, which hold only 12. Check the pack count against the original quantity before using it in a later order or fulfilment step.

3. Run it and check the output

  1. Click Run once. Wait for both modules to finish successfully.
  2. Click the small result bubble above the second module.
  3. Under Output, check that packs_needed is 3. The comparison values should both be 2.
For 13 items, ceil returns three packs. Round and floor return only two.

Full Make run output showing three packs from ceil and two from round and floor for 13 items

Full Make run output showing three packs from ceil and two from round and floor for 13 items

For 13 items, ceil returns three packs. Round and floor return only two.

Open full-size image

The comparison uses Make's documented round and floor functions (opens in a new tab). Round chooses the nearest integer; floor chooses the integer below or equal to the value. For whole-pack capacity, either can produce too few packs when the division has a remainder.

4. Check an exact multiple and zero

  1. Open the first module and change items_needed to 12. Save the module and click Run once again.
  2. Open the second module's result bubble. All three outputs should be 2. Ceil keeps an exact whole-pack result unchanged.
  3. Repeat with items_needed set to 0. All three outputs should be 0, meaning no packs are needed for this calculation.
  4. Restore 13 if you want to retain the example. Save the scenario and keep it Inactive.
For 12 items in packs of six, all three functions return exactly two.

Full Make run output showing two packs from all three functions for 12 items in packs of six

Full Make run output showing two packs from all three functions for 12 items in packs of six

For 12 items in packs of six, all three functions return exactly two.

Open full-size image

Each manual run calculates from its current inputs. It does not reserve stock or place an order. When adapting this to real records, check the item's pack size and units, and reject missing, negative or invalid inputs before they reach the calculation.

If the result is wrong

If the output contains formula text, reopen the value field and check that the function and mapped inputs appear as tokens. If it uses the wrong quantity, check the input module's number and inspect that run's input values. A different module number requires different mapping tokens.

Keep the original quantity alongside the calculated pack count. A result of three packs does not mean three items, and this simple calculation does not account for supplier minimums, mixed pack sizes or available stock.

To compare ceil, round and floor with the fictional quantities above, start with Make Free (opens in a new tab). Check the exact-pack and zero cases, then keep the practice inactive. This calculation does not place an order.

Sources: Make math functions (opens in a new tab), using functions (opens in a new tab), scenario variables (opens in a new tab).

Share this guide

From holdmytwist.com/guides/make-ceil-whole-packs/