I'm working on categorizing tires and rims that I own. I want the sheet to look into the "Width", "Ratio" and "Rim Size" columns to provide me with data to determine which car it would fit on.
For example: D2=215, E2=55, F2=16 This would be a tire of 215/55/R16.
So in pseudocode:
if D2=215 && E2=55 && F2=16 then C2="Fits Ford Crown Vic/Taurus"
And to expand, I would hope it could be easier with a switch statement so that I could make it more complicated.
if D2=(between 215 and 235) && E2=(between 55 and 65) && F2=(between 16 and 18) then C2="Fits Ford Crown Vic/Taurus/Charger"
Would it be easier to write a script to go with it instead?