Jan 12 2023
Using - Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit
I have a list of trucks, their size in cubes, and weight in pounds.
I would like to create a template where I can drop that info (changes each day) and have a column that sorts them:
van a - under 6000 lbs
van b - under 4000 lbs
28 ft - over 4000 lbs, under 650 cube
36 ft - under 850 cube
48 ft - under 1350 cube
How could I do this? Where it references the cell and chooses an option above based on the ranges between different vehicles?