Use An If Function In Cell G15 To Calculate The Net Price

Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate. [6 points]

Need your ASSIGNMENT done? Use our paper writing service to score good grades and meet your deadlines.

Order a Similar Paper Order a Different Paper