Question: I am having trouble with my excel class. Setting up formulas. I am not sure how to set up this formula with this task. :

I am having trouble with my excel class. Setting up formulas. I am not sure how to set up this formula with this task. :

in cell i11, enter a formula using the if function and structured references that tests whether the value in the tier field is equal to "platinum". if it is, multiply the value in the total sales field by 0.05. otherwise, enter 0 (zero) in the cell.

Can you help me set up this formula?

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

Week One: Payment Calculator Getting out of debt is an important goal for most people. Sometimes it takes a lifetime, but however, long it takes, the time will most likely be shortened by following a...

FIN 5823 Week One: Payment Calculator PLEASE HELP TO IMPLEMENT A LOAN PAYMENT CALCULATOR WITH MS EXCEL FORMAT. STEPS ARE SHOWN BELOW: Getting out of debt is an important goal for most people....

i nedd help with data entry in excel DATA ENTERY IN EXCELL I was looking for someone who can enter the information provided in excel. this class is stat 1400 the data is within the pictures i sent. i...

2 First, you want to calculate the number of days between the Initial Deadline and the Date Received. In cell D11, insert the DAYS function using the Initial Deadline that is stored in cell B8 and...

Excel Lab # 1 : Descriptive Stats, Tables and Graphs 2 0 2 2 W Excel Lab 1 - Descriptive Stats Tables and Graphs Instructions January 2 0 2 2 . docx Page 1 of 1 0 This tutorial requires Excel skills...

MGMT 4 2 6 - Assignment # 1 Forecasting Purpose of Assignment In this assignment, you will develop forecasting skills which are widely used in industry and highly valuable since a forecast is the...

Ay Yourse 121 Apply Your Skills EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors this exercise, you will complesummary data based on an inventory Listing for...

You work in the Admissions Office for a small regional university in Massachusetts Your assistant entered a list of college applicants for the Fall 2021 semester. You determine if a student qualifies...

First, you want to calculate the number of days between the Initial Deadline and the Date Received. In cell D11, insert the DAYS function using the Initial Deadline that is stored in cell B8 and the...

please help me this one, using Excel Thank you so much EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors In this exercise, you will compile summary data based on an...

A 60.0-cm, uniform, 50.0-N shelf is supported horizontally by two vertical wires attached to the sloping ceiling (Fig. 11.23). A very small 25.0-N tool is placed on the shelf midway between the...

Which of the following factor will affect the dividend policy of the firm? 1. Insufficiency of cash 2. Firms contractual obligation 3. Ratio of debt to equity. 4. Business cycle considerations Select...

9. (LO4) Explain why the after-tax borrowing rate is the appropriate discount rate to use in lease evaluation.

Lemmon Enterprises has a total asset turnover of 2.1 and a net profit margin of 7.5%. If its equity multiplier is 1.90, what is the ROE for Lemmon Enterprises?

Norton Company has a debt-to-equity ratio of 1.65, ROA of 11.3 percent, and total equity of $1,322,796. What are the companys equity multiplier, debt ratio, and ROE?

Charger Corp. has $ 500,000 of income from continuing operations and $ 300,000 of income from discontinued operations. In the prior year, Charger finished the year with a $ 1.2 million net operating...

Sorenson Inc. has sales of $3,112,489, a gross profit margin of 23.1 percent, and inventory of $833,145. What are the companys inventory turnover ratio and days sales in inventory?

Yankee Corporation has suffered a large net operating loss. Which sources of income should be considered when estimating the future realization of a tax benefit from this loss? Briefly describe each....

A pointer holds a memory address.

Do not move closer than an arms distance. (This distance literally applies to Northern Europe. In Southern Europe this distance is slightly smaller.) If you get closer than this distance, you seem...

2. Now list, after going through a-c, three things that you want to be the impres-sion you want others to be left with after meeting you, and that you want to be lasting over time. List four points...

Relax your shoulders