Ravi Sir's Cards › Excel
Petrol Pump Shift Management System in Excel (card 2 of 2)
Revision card 2 for Petrol Pump Shift Management System in Excel: Short or excess: =ROUND(G5-H5,2) gives −₹20.9; Shortage check: =IF(I5<-Setup!$B$4,"Short","OK") gives OK; Book stock: =B5+C5-D5 gives 9,112.
Read card text
What this card says
2 for Petrol Pump Shift Management System in Excel: Short or excess: =ROUND(G5-H5,2) gives −₹20.9
Shortage check: =IF(I5<-Setup!$B$4,"Short","OK") gives OK
Book stock: =B5+C5-D5 gives 9,112.
Learn this in the lesson: Petrol Pump Shift Management System in Excel: Meter Readings, Litres Sold, Cash and UPI Collection, Shortage and Tank Dip