This should be a basic formula but I can't seem to figure it out. I've asked similar questions in the past but my brain is not working at the moment to figure out how to solve this. It's very basic, I would like to have a formula in the highlighted cells (the weight cells next to them would be dynamic and would change, but the formula would return the appropriate value).
If the weight value is 0.8 LB, the formula should return the rate for 1 LB, so it would essentially lookup the table and try to find a rate for 0.8 LB and if it can't find it then it would look for the rate with the next higher weight, in the example attached being 1.0 LB.
Thanks
Bookmarks