Answered You can hire a professional tutor to get the answer.

QUESTION

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]

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question