Great! I can assure you there are really great experts on the board who are willing to provide amazing solutions when you provide enough information. However, helpers cannot know what you exactly need without knowing the existing structure, and future readers also cannot know what the solution means without knowing the exact question.

I can follow the thread easily and see how joeu2004 explained how you can use the

`ROUNDUP`

function without knowing your actual formulas.

Then as soon as you pasted some sample data, without formulas still, provided more information according to your a bit more revealed structure.

Of course, the

`the C/limit calc`

is your hidden formula in the structure as also explained as "a monthly expenditure and we take the percentage of the monthly expenditure against to the overall total to the the % monthly expenditure and then that percentage and being multiplied to the tier table" in the first reply. So it is just a reference as explained in the first reply.

As you can see, this is equivalent to the following formula:

Excel Formula:

`=CEILING(the C/limit calc,10000)`

When you place the necessary formula as you did in your solution post, you'll get the exact same result.

And this has been provided in the second reply. That's why I switched the solution post to provide optimal help to future readers.