Excel table How to quickly calculate the postage of each express item

For express statistics, because each express arrival location is different, so the charges will not be the same, this period introduces a quick way to help express statisticians use Excel quick statistics all over the postage

1, first look at the effect

2, the first to create a secondary column, known as the regional costs, we use VLOOKUP to quote the area, the formula, if you do not understand the VLOOKUP function, you can see the previous experience

3, then the data to pull down, so you can get all the area cost data

4, Next, we can calculate the postage, the use of the IF function (the previous experience is also said, not clear to see), the formula below, the formula is, if more than 1 return 5 Yuan + regional costs, if more than 1 return, 5 Yuan + more than 1 times 3+ area costs.

5, and then pull down to get the full postage

6, here can also be a variant of the formula, the VLOOKUP embedded into the IF, meaning that the auxiliary column to replace with VLOOKUP, the formula as shown

Note: VLOOKUP function Reference remember to refer to the area of the F4 for absolute reference, otherwise there will be problems