Question: I need help on creating an equation for the following (I am working on media math for selling ad time on radio) Multiply the gross

I need help on creating an equation for the following (I am working on media math for selling ad time on radio)

Multiply the gross amount by .15 to take out the agency discount

Then you take that number and multiple by .21

Here is an example: Gross is $100: 100x.15= 15 ; 100-15= 85; 85x.21= 17.85; 85-17.85 = 67.15

I need one excel formula to make that entire calculation. The amount 100 would be in a cell and the amount 21% would also be in a cell.

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 Mathematics Questions!

Q:

Computerized Accounting with Sage 50 Level 2 The Dog House INTRODUCTION This project will test your understanding of the Sage 50 Accounting application and your ability to apply the features of this...

Q:

Using the pages below, answer the following questions; Chapter 10 Read P.218- 223 Answer 223 Q.1-3 Read P.224-234 Answer P.234 Q.1-3 AS YOU READ . -. . YOU WILL LEARN ' To dene entertainment...

Q:

MKT500 Week 7 Discussion Board I have attached the question, lecture notes, and an example of a student's response to the questions. Running head: KEYSAN NATURALS COMPANY: AIDA PRINCIPLE Keysan...

Q:

Please helpFrom the text- please make one annotation per page Workbook please complete using the text 4 Files 4:01 PM Fri May '13 Insert Draw Layout Review View Unit 4Economic Indicators Name: HR:...

Q:

Exam 1 Business Math Q1. The number 49,842 rounded to the nearest thousand is: a. 50,000 b. 49,000 c. 49,900 d. 49,800 Q2. The number 70624020 should be written: a. 70,624,020.0 b. 7,062,402,0 c....

Q:

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

Q:

Alberto Perlman walked out of the old warehouse that served as the offices of Zumba Fitness and into the hot Miami sun. He had just finished meeting with his two partners, and the company that they...

Q:

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Q:

I am working on my group project for the class teaching by prof. Karen Kukla. My group chose the business EduXperience . There are 3 part of the project: and I need help for question 2. Description...

Q:

I am working on my group project for the class teaching by prof. Karen Kukla. My group chose the business EduXperience . There are 3 part of the project: and I need help for question 2. Description...

Q:

Int. J. Business Excellence, Vol. X, No. Y, xxxx From stale to spicy to superb: a spanking new Apple John Wang* Department of Information and Operations Management, Montclair State University,...

Q:

List and briefly define key requirements for WLANs.

Q:

Each of the following continuous-time signals is used as the input x c (t) for an ideal C/D converter as shown in Figure with the sampling period T specified. In each case, find the resulting...

Q:

2. Which jump instructions follow signed integer comparisons?

Q:

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...