What formula would you use notate this question in Excel. It costs 6.50 for the first gallon of milk, and 5.50 for each additional gallon.

Thank you for the opportunity to help you with your question!

Formula is $C= 5.5× (g-1) + 6.50 where C is the cost and g is the number of gallons bought

milk.ods

The problem we are running into is the account for 0, when no one purchases milk. So when 0 is entered it comes out with $1.

No there is a restriction that g must be =>1

or you can also say that C = 0 for g =0

and C= 5.5× (g-1) + 6.50 where C is the cost and g is the number of gallons bought and is=>1

Secure Information

Content will be erased after question is completed.

Enter the email address associated with your account, and we will email you a link to reset your password.

Forgot your password?

Sign Up