can someone solve this

3. The pricing schedule for olive oil is as follows: A Cost/gallon for the first 500 gallons Cost/gallon for next 500 gallons Cost/gallon for gallons > 1,000 $23 $20 $15 1 2 3 4 5 6 7. N 1600 483 2001 Write a nested-IF statement to calculate the quantities of olive oil listed in cells A5, A6, and AT