Ravi Sir's Cards › Excel
Dairy Milk Collection System in Excel (card 1 of 2)
Revision card 1 for Dairy Milk Collection System in Excel: Amount for the pouring: =ROUND(E5*H5,2) gives ₹180.2; Net payable: =E5-F5 gives ₹3,215.7; Bill period as text: =TEXT(Setup!B4,"dd-mm-yyyy")&" to "&TEXT(Setup!B5,"dd-mm-yyyy") gives 01-10-2026 to 10-10-2026. Includes an example data table.
Read card text
What this card says
1 for Dairy Milk Collection System in Excel: Amount for the pouring: =ROUND(E5*H5,2) gives ₹180.2
Net payable: =E5-F5 gives ₹3,215.7
Bill period as text: =TEXT(Setup!B4,"dd-mm-yyyy")&" to "&TEXT(Setup!B5,"dd-mm-yyyy") gives 01-10-2026 to 10-10-2026. Includes an
Example
data table
Learn this in the lesson: Dairy Milk Collection System in Excel: Fat and SNF Rate Chart, Shift Entries, Farmer Bills and Dashboard