A shipping company determines shipping rates based on destin…
A shipping company determines shipping rates based on destination and package weight. If the Destination (cell A2) is “International”, the shipping rate is $25. If the destination is not International, then check the Weight (cell B2): If the weight is 20 pounds or less, the rate is $5. If the weight exceeds 20 pounds, the rate is $10. Write the nested IF formula.