Ravi Sir's Cards › Excel
Printing Press Management System in Excel (card 2 of 2)
Revision card 2 for Printing Press Management System in Excel: Plate cost: =G5*H5*Setup!$B$4 gives ₹2,800; Printing cost: =ROUNDUP(MAX(1000,N5)/1000,0)*G5*H5*Setup!$B$5 gives ₹4,800; Total cost: =O5+P5+Q5+R5 gives ₹10,488.6.
Read card text
What this card says
2 for Printing Press Management System in Excel: Plate cost: =G5*H5*Setup!$B$4 gives ₹2,800
Printing cost: =ROUNDUP(MAX(1000,N5)/1000,0)*G5*H5*Setup!$B$5 gives ₹4,800
Total cost: =O5+P5+Q5+R5 gives ₹10,488.6.
Learn this in the lesson: Printing Press Management System in Excel: Job Estimator, Paper and Plates, Quotation, Delivery Status and Dashboard