r/excel•
Reaper4779

Looking for formula to return highest value based on multiple criteria

unsolved

I'm creating a tool for work in excel that will look at multiple criteria for each state that we run through and return the highest number of escort cars that are needed. I work for a trucking company and we deal with oversized loads.

To give an example in Georgia if our overall length of a truck and trailer is over 100' we need to have 1 escort and if our width is over 14'8" at the same time we will need 2 escorts total due to the width. If one requirement demands a higher number of cars we use that. In this example I would need 2 total cars being the width meets a higher number needed, it is not a combined number between both requirements.

I created an ifs formula that figures out the correct number of cars needed based on length but if I enter over the 14'8" dimension into the calculator it does not return 2 when needed but 1. Its taking the first correct answer and returning that rather than the highest number needed.

Is there another formula or way of working the ifs that will return the highest number based on the dimensions I entered?

Posted Jul 8, 2025, 4:52 PM UTC

212
Loading comments…