Solved: Excel a tollway truck plaza gives a discount on diesel fuel, Business Management

+44 141 628 6080
[email protected]

Excel a tollway truck plaza gives a discount on diesel fuel

Excel) A tollway truck plaza gives a discount on diesel fuel to truckers based on the total quantity they purchase. Which of the formulas below calculates the correct total price to charge a customer for the diesel pumped based on the following conditions:

no discount (zero dollars off the total due) if the trucker purchases less than 50 gallons of diesel
a 2% discount on all diesel purchased if the trucker buys at least 50 gallons of fuel

Assume that cell A1 shows the total quantity (in gallons) of diesel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that the trucker should pay, after discount (if any) has been applied.

		=IF(A1>50,A1B198%,A1*B1)
		=IF(A1<50,A1B1,A1B1-(A1B198%))
		=A1B1IF(A1<50,1,98%)
		=A1IF(A1<50,B1,2%B1)

View Complete Question

Solution Preview :

Prepared by a verified Expert

Business Management: Excel a tollway truck plaza gives a discount on diesel fuel

Reference No:- TGS02203065

Now Priced at $10 (50% Discount)

Recommended (93%)

Rated (4.5/5)

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Asked Questions

Create the social policies that would allocate the necessary

This type of disempowerment exists where a collective voice is absent either in civil society or within political institutions

Where do you locate your potential participants for study

As a researcher studying a community with a high level of substance abuse. Where do you locate your potential participants for the study?

Find local agencies that resources to children-families

Find information on 10 LOCAL agencies (Anderson, Pickens, Oconee, Greenville counties) that offer resources to children and families.

What is your unique social location

What is your unique social location? I am a 20-year-old, straight, white female, college student, living in Missouri, United States of America, and Christian.

What is an intercultural encounter you have had in your life

What's an intercultural encounter you've had in your life that stands out to you? What makes this encounter intercultural?

How does the social process of labeling and making the label

How does the social process of labeling and making the label stick [accepted] connect secondary deviance with primary deviant actions?

Find opportunity to explore social construction of reality

In this journal you will have the opportunity to explore the social construction of reality, the process by which people creatively shape reality through social

		=IF(A1>50,A1B198%,A1*B1)
		=IF(A1<50,A1B1,A1B1-(A1B198%))
		=A1B1IF(A1<50,1,98%)
		=A1IF(A1<50,B1,2%B1)

Solution Preview :

Prepared by a verified Expert

Business Management: Excel a tollway truck plaza gives a discount on diesel fuel

Reference No:- TGS02203065

Have a Question? (oR Write a Review)

Recent Questions Asked Business Management

Q : What is the primary target of systems design and what

Q : Create an automobile class for a dealership include fields

Q : Webster dictionary gave a number of definitions of

Q : What was learned from the accident how can an event such as

Q : Excel a tollway truck plaza gives a discount on diesel fuel

Q : Using these key parts write a java program that will allow

Q : Describe the sql keyword like and how it is used include a

Q : 1 what is a buffer overflow use the internet to find a

Q : Working together jack and bob can clean a place in 30