Ravi Sir's Cards › Excel
Mobile Repair Job Card System in Excel (card 2 of 2)
Revision card 2 for Mobile Repair Job Card System in Excel: Days taken: =IF(O5<>"",O5-B5,"") gives 2; Warranty till: =IF(O5<>"",O5+Setup!$B$6,"") gives 02-11-2026; Parts used: =COUNTIF(Jobs!$F$5:$F$500,A5) gives 3. Includes an example data table.
Read card text
What this card says
2 for Mobile Repair Job Card System in Excel: Days taken: =IF(O5<>"",O5-B5,"") gives 2
Warranty till: =IF(O5<>"",O5+Setup!$B$6,"") gives 02-11-2026
Parts used: =COUNTIF(Jobs!$F$5:$F$500,A5) gives 3. Includes an
Example
data table
Learn this in the lesson: Mobile Repair Job Card System in Excel: Jobs, Parts Stock, Status Flags, Warranty and Dashboard