1. Semester Assignment 1 in 2016 (20%) For the following table, (in ms excel) Suppose the unit price (in column B) varies A B C D 1 unit quatity price per unit quantity total price 2 1 to 10 35 birr 3 11 to 20 30 birr 4 21 to 30 25 birr S 31 to 40 20 birr 6 41 to 50 15 birr 7 Above 50 10 birr Grand tofal - B2 x C2 depending on the specified quantity (in column A) and you are asked to write a formula that calculates the total price (in cell D2) of any amount of item input in cell C2. (5 points) (Hint use IF function in cell D2 based on cell C2)
