Okay Excel geniuses, let's see what you've got.
I am building a structure in Minecraft and need to do some math and have all of my ducks in a row before starting. Here's exactly what I have and will need:
In each inventory slot, you can hold up to 64 of a single item before another slot starts filling up. So if I have 70 stone blocks, I will have 1 full slot of stone blocks, plus 8 in another. If I have 255 stone blocks, I will have 3 full slots plus 63 in another. Got it?
I know MOD() will get the remainder, but I need to output this in a single cell with the number of full slots and the remainder together, so something formatted like "3 r63" or anything else easily readable is needed. There will be at least 123 different values, so an expression that I can copy and drag paste would be preferable.
I am building a structure in Minecraft and need to do some math and have all of my ducks in a row before starting. Here's exactly what I have and will need:
In each inventory slot, you can hold up to 64 of a single item before another slot starts filling up. So if I have 70 stone blocks, I will have 1 full slot of stone blocks, plus 8 in another. If I have 255 stone blocks, I will have 3 full slots plus 63 in another. Got it?
I know MOD() will get the remainder, but I need to output this in a single cell with the number of full slots and the remainder together, so something formatted like "3 r63" or anything else easily readable is needed. There will be at least 123 different values, so an expression that I can copy and drag paste would be preferable.
