About this document

Correlation Between Laser Printers and Cartridges by Đặng Thanh Thuỷ is a document available to read on EtoBox.

Here is a formula to calculate the purchase cost as a function of the number of units purchased based on the pricing tiers: =IF(A2<501,3,IF(AND(A2>=501,A2<=1200),2.7,IF(AND(A2>1200,A2<=2000),2.3,2)))*A2 Breakdown: - IF(A2<501,3) - If quantity is less than 501, unit price is $3 - IF(AND(A2>=501,A2<=1200),2.7) - If quantity is between 501-1200, unit price is $2.7 - IF(AND

Author

Đặng Thanh Thuỷ

Language

EN