Ravi Sir's Cards › Excel
CA Office Compliance Management System in Excel (card 2 of 2)
Revision card 2 for CA Office Compliance Management System in Excel: GST on the fee: =ROUND(D5*Setup!$B$5,0) gives ₹1,080; Pending for the compliance: =COUNTIFS(Compliance!$C$5:$C$500,A11,Compliance!$E$5:$E$500,"") gives 1. Includes an example data table.
Read card text
What this card says
2 for CA Office Compliance Management System in Excel: GST on the fee: =ROUND(D5*Setup!$B$5,0) gives ₹1,080
Pending for the compliance: =COUNTIFS(Compliance!$C$5:$C$500,A11,Compliance!$E$5:$E$500,"") gives 1. Includes an
Example
data table
Learn this in the lesson: CA Office Compliance Management System in Excel: GST and TDS Due Dates, Filing Status, Fees and Staff Report