Is there a way to change the max value of the number behind comma?

**Jesh1337** · 02-23-2020, 11:49 AM

Hey.

I am not very skilled in excel and also English is my second language so describing math related problems is a little difficult but i will try.

What I am trying to do is to have one cell where I can fill inn an number and then one cell that divides that number by lets say 64. But i also want the number behind the comma to be maximum 64 as well not 100. so that whenever there 0.64 it becomes 1.

I also need this to be different in all the cells so that one is 64 and another is for example 56.

Example:

______A__________B_____
1|__200___|__=a1/64__|
2|__200___|__=a2/56__|

Then the results would be:

______A__________B_____
1|__200___|____3,8____|
2|__200___|____3,32___|

Is this possible?

I tried asking this on reddit as well and so far none of the solutions seems to work

**Pepe Le Mokko** · 02-23-2020, 12:18 PM

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

**FlameRetired** · 02-23-2020, 01:07 PM

Edited Simpler formulas.

A workbook upload is still preferable. In the meantime try these with the understanding you will need to change the "." to ","

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**Jesh1337** · 02-23-2020, 01:46 PM

Thank you so much!

it worked the way i needed it too without changing , to .

again thanks.

**FlameRetired** · 02-23-2020, 01:56 PM

You are welcome. Thank you for the feedback, added rep and marking your thread Solved.

**Jesh1337** · 02-27-2020, 10:09 PM

Sorry for reviving an old thread but I ran into an issue.
I think maybe my approach to the problem initially was wrong.

The formula worked like i wanted it to but the results aren't optimal.

Lets say my company sells boxes with 64 units of something inside, so there is an order of 330 units then we would ship out 5 boxes and 10 individual units.
Or if the order is 321 units then we would ship out 5 boxes and 1 individual unit.

The problem I ran into is that with the formula is that both 321 and 330 gives the answer 5.10, but ideally 321 would be 5.01

Does anyone know if there is a way to solve the problem described above? as I would like to make an excel sheet with several orders that I can change the numbers of the orders in excel to get the amount of boxes and units quickly instead of having to manually calculate each order

(Im trying to upload a sheet but the attachment button doesnt seem to work on my browser, I will try from a different device :S )