CS 285 Lecture 3: CS 285 Module 4 Notes
15 Oct 2017
School
Department
Course
Professor
Document Summary
\vlookup to find an exact match for the sale status of scarves. Use the value in cell l6 as the lookup_value, the range b3:j14 as the table_array, 9 as the col_index_num argument, and false as the range_lookup argument. To create the following formula: subtract the launch date in cell b4 from the data updated date in cell d20. To show the time in years, divide that result by 365. Use an absolute reference to the date in cell d20. Create a formula using the if function to test whether or not the item beaded earrings should go on sale. It will go on sale if its current sales rank (in cell g4) is 8th or lower. (hint: if the cell value is greater than or equal to 8, it will go on sale. ) Do not use any spaces in the formula. No negative sign is needed in this formula, based on the sam project instructions.
