Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Question What should my function be for: 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 (0%), E11(2%) and E12(5%) for your IF function arguments. Use absolute and relative references when appropriate. I literally just need a formula :(

/in /by

Question

What should my function be for: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 (0%), E11(2%) and E12(5%) for your IF function arguments. Use absolute and relative references when appropriate. I literally just need a formula 🙁

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"