Formula to read dimensions of freight to calculate how many pallet spaces

I've been testing out formulas and reading forums all day to try and figure out how to build a pallet space calculator.
I'm not an intermediate excel user by any means unfortunately.

I enter in the length, width, height and weight of the item being freighted. I would then like the spreadsheet to calculate how many pallet spaces on the truck this would use based on my standard pallet measurements and disregarding the height of the freight.

For example a piece of machinery is being freighted. 2.7m long and 2m wide. The height won't matter as it is machinery craned on. How many pallet spaces did it take up to the nearest 0.25m

I then want to be able to identify which is greater. The amount of pallet spaces required for the item or the weight based on 1000kg per pallet space.