1. In the sheet named '2016 Orders', include a column after Totalw/Dis' called 'Unit Cost'. 2. In the 'Unit Cost' column, use vLookup function

1. In the sheet named "2016 Orders', include a column after "Totalw/Dis' called 'Unit Cost! 2. In the 'Unit Cost' column, use Lookup function to pull product unit costs from the Income Statements sheet, to show costs for all products. 3. Add a column, right after or wherever appropriate, after Unit Cost called "Cost Appreciation' 4. In this column, usen nested If function to decide which products are facing an increase in costs due to inflation The products that have unit cost greater than $45 should be labeled as TH for Inflationary Hike. Products that have unit costs less than $30 should be labeled 'DD' for Deflationary Dip. All other products should be labeled 'RI for routine increase 1. In the sheet named "2016 Orders', include a column after "Totalw/Dis' called 'Unit Cost! 2. In the 'Unit Cost' column, use Lookup function to pull product unit costs from the Income Statements sheet, to show costs for all products. 3. Add a column, right after or wherever appropriate, after Unit Cost called "Cost Appreciation' 4. In this column, usen nested If function to decide which products are facing an increase in costs due to inflation The products that have unit cost greater than $45 should be labeled as TH for Inflationary Hike. Products that have unit costs less than $30 should be labeled 'DD' for Deflationary Dip. All other products should be labeled 'RI for routine increase

1. In the sheet named '2016 Orders', include a column after "Totalw/Dis' called 'Unit Cost'. 2. In the 'Unit Cost' column, use vLookup function to pull product unit costs from the Income Statements sheet, to show costs for all products. 3. Add a column, right after or wherever appropriate, after 'Unit Cost' called 'Cost Appreciation' 4. In this column, use a nested If function to decide which products are facing an increase in costs due to inflation. The products that have unit cost greater than $45 should be labeled as 'TH' for Inflationary Hike. Products that have unit costs less than $30 should be labeled 'DD' for Deflationary Dip. All other products should be labeled 'RI' for routine increase.