Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can't figure out the answer File Home nsert Draw Page Layout Formulas Data Review View Cut Calibri 11 AA e wrap Text Paste Format Painter
Can't figure out the answer
File Home nsert Draw Page Layout Formulas Data Review View Cut Calibri 11 AA e wrap Text Paste Format Painter Clipboard Font Alignment G6 1 Gallons PPG Total 33 S 2.22 A truck stop on a major interstate highway gives a discount on diesel to truckers based on quantity purchased. Write a formula which calculates the correct price to chargea customer based on the following conditions: 1. no discount (zero dollars off the total amount due) if the customer purchases less than twenty gallons of diesel 2. a 1% discount on the total amount of diesel purchased if the customer buys more than twenty gallons of fuel, but less than forty gallons 3. a 3% discount on all fuel purchased if the customer buys fifty or more gallons of diesel for their big rig Assume that cell A2 shows the total quantity (in gallons) of diesel purchased and cell B2 is the price per gallon of fuel. Your formula should properly calculate the total amount that the trucker should pay for the purchase of diesel fuel, after a discount (if any) has been applied 4
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started