Question: Excel Logic based question - Anyone can help with this formula in Excel? all I know it should be a Nested if formula Olive Oil

Excel Logic based question - Anyone can help with this formula in Excel? all I know it should be a Nested if formula

Excel Logic based question - Anyone can help with this formula in

Olive Oil Logic 2 Cost/gallon for the first 500 gallons: $23 Cost/gallon for the next 500 gallons 20 Cost/gallon for gallons>1,000: Logic Used for the Olive Oil Problem in the Proficiency Exercises $15 Number of gallons: 1,600 483 2001 Check: should be 30,500 should be 11,109 should be 36,515 Formulas to calculate the cost of: 1600 gallons: 483 gallons 2001 gallons

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!