exel Microsoft

Team Assignment Suppose that a product's price changes over time. I know the date the product was sold. How can I write a formula to compute the product's price? Please write a formula to determine the correct product price for any date on which the product is sold in th 2005. Price January-April 2005 $98 Find the price for 1st of April 2005, 5th of October 2005, 9th of December 2005 and 5th of January 2005 May-July 2005 $105 August-December 2005 $112 Lookup Tables TRUE FALSE Column1 Income Level Tax Rate Income Rate 0 0.15 -1000 #N/A 10000 0.3 30000 0.34 30000 0.34 29000 0.3 0.34 100000 0.4 98000 104000 0.4 Team Assignment Suppose that a product's price changes over time. I know the date the product was sold. How can I write a formula to compute the product's price? Please write a formula to determine the correct product price for any date on which the product is sold in th 2005. Price January-April 2005 $98 Find the price for 1st of April 2005, 5th of October 2005, 9th of December 2005 and 5th of January 2005 May-July 2005 $105 August-December 2005 $112 Lookup Tables TRUE FALSE Column1 Income Level Tax Rate Income Rate 0 0.15 -1000 #N/A 10000 0.3 30000 0.34 30000 0.34 29000 0.3 0.34 100000 0.4 98000 104000 0.4