Use an IF function in Cell G15 to calculate the Net Price. There is a discount of
Fantastic news! We've Found the answer you've been seeking!
Question:
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 you If function arguments. Use absolute and relative references when appropriate.
Related Book For
Intermediate Accounting
ISBN: 978-0470423684
13th Edition
Authors: Donald E. Kieso, Jerry J. Weygandt, and Terry D. Warfield
Posted Date: