Hi please help with how to build formula in excel for
- If Delivery Zip Code is (1) greater than or equal to the listing in column D AND (2) less than or equal to listing in column E
- AND Pickup Zip Code's first 3 character is (1) greater than or equal to listing in column A AND (2) less than or equal to listing in column B
- THEN (output is number in) column C
- If Delivery Zip Code is (1) greater than or equal to the listing in column D AND (2) less than or equal to listing in column E
- AND Pickup Zip Code's first 3 character is (1) greater than or equal to listing in column A AND (2) less than or equal to listing in column B
- THEN (output is number in) column C