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

CA

94203

Steven Buchanan

4525 Urn Hollow Road

Olive Branch

MS

38654

Mozzarella di Giovanni

$10.70

20

214

Yellow

$49.35

5%

$10.70

$20.84

$273.49

1

0

A11= Overdue

A12= 1

A13=30 etc...

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