Question: I need help on this.... In column Y, use a formula to compute the OrderStatus. If the Paid value is 1 (column W), the OrderStatus

I need help on this....

In column Y, use a formula to compute the OrderStatus. If the Paid value is 1 (column W), the OrderStatus is OK. If not, if Paid is 0 then, then lookup DaysDue (column X) in the Overdue table to get the OrderStatus. Hint: Use IF(), or IFS() and VLOOKUP()

CompanyName

Address

City

State

Zip

Salesperson

SP_Address

SP_City

SP_State

SP_Zip

ProductName

UnitPrice

Quantity

LineSubtot

Promo

Freight

DiscPerc

DiscountAmt

Tax

LineTotal

Paid

DaysDue

OrderStatus

Vins et alcools Chevalier

7142 White Oak Lane

Sacramento

94203

Steven Buchanan

4525 Urn Hollow Road

Olive Branch

38654

Mozzarella di Giovanni

$10.70

214

Yellow

$49.35

$10.70

$20.84

$273.49

A11= Overdue

A12= 1

A13=30 etc...

Overdue
1	<30Days
30	30+Days
60	60+Days
90	90+Days
120	120+days

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 General Management Questions!

I need help on this.... In column Y, use a formula to compute the OrderStatus. If the Paid value is 1 (column W), the OrderStatus is OK. If not, if Paid is 0 then, then lookup DaysDue (column X) in...

NEED URGANT HELP PLEASE this an excel projec Supermarkets often advertise that they have the lowest prices. But is there really a difference in the cost of groceries at different stores? Have you...

Please help me with this question about The Chi Square ( 2 ). For this practice excercise you will NOT need to use the data for the words that were not studied. 3? 38 39 4O 41 42 43 44 45 46 47 48 49...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

i need help follwing the steps and putting in the formulas right on excel 10 10 To build the table that will list the loan payments, Excel PMT function will be put to work Click in cell C14 Enter the...

Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work Use Apple's financial statements in Appendix A to answer the following. Required: 10 1. Using fiscal 2017 as...

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...

Below Excel File: While Answering write down formula you used to solve question. Thanks Using Scenarios and Data Tables to Support Pricing Decisions Water Company has used a two-tier price structure...

The attached file contains explanations on how to complete the excel assignment. You MUST follow all rules and formulas to get the solutions...etc/ Please send me the completed excel sheet that...

Tiffanys provides financial services related to investment selections, retirement planning, and general insurance needs. For the current year, the company reports the following amounts: In addition,...

Make an argument in support of Britt.

Lease versus Buy apply: 1 . The machinery falls into the MACRS 3 - year class. ( The depreciation rates for Year 1 through Year 4 are equal to \ ( 0 . 3 3 3 3 , 0 . 4 4 4 5 , 0 . 1 4 8 1 \ ) , and 0...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...