There’s probably a way to make this work using ROUNDUP(), but having been an English major, I took the low road and did it this way:

IF(

    MOD(

        ({H1 Vol}*{Dosage}*3.0)/1000,

        1.5

        )>0,

    (INT((({H1 Vol}*{Dosage}*3.0)/1000)/1.5)+1)*1.5,

    ({H1 Vol}*{Dosage}*3.0)/1000

    )

Essentially, it checks to see if the calculated amount is evenly divisible by 1.5. If it is, fine; if not, it takes the integer quotient, adds 1, and multiplies the result by 1.5. I tossed a few numbers at it, and it seemed to work — but because of the way Discourse (the software running this forum) interpreted your embedded '*'s, I had to guess at your formula and field names, so you’ll want to double-check my work.

Hi @Tyrone_Elliott - the formula you’ve posted above has got a bit mashed in the post formatting so hard to see exactly what you’re using, but a couple of thoughts:

1. 
   

   ROUNDUP should always have a precision - precision of 0 rounds up to the next integer value. Because of the formatting, I couldn’t figure out if the precision value is there or not.

   
   


2. 
   

   Worth trying to calculate the total weight value first (in one column) then do the roundup in another column - sometimes easier to debug and figure out what is going on (you can always combine these down to a single field/column once you have it working correctly).

   
   

To answer your question though, ROUNDUP should do the trick. My example below (I’ve simplified the data, but hopefully still valid) illustrates:

So in this case, “Value” is your calculated value; “Exact” is a formula:

Value/1.5

To show the exact number of tins required; “Roundup” is a formula on “Exact”:

ROUNDUP(Exact, 0)

Hope this helps!

JB