Excel Formula
This query is : Resolved
Sankar Chakraborty
(Querist)
13 August 2009
while preparing balance sheet in excel sheet i want to use a cell to show difference between total asset & total liabilities viz if any diff. is occured only then display as "Difference" in red filled colour , otherwise not
please let me know how should i do the same as i have seen it in a CA office
please let me know how should i do the same as i have seen it in a CA office
CA Vanesh Nadar
(Expert)
13 August 2009
IF you are using the Microsoft Office than you can use the condional formula in the tools option.
Vishnu Saboo
(Expert)
14 August 2009
let cell A1 is total of asset and B1 is total of liabiliies
=if(or(a1-b1>0,a-b1<0),a1-b1," ")
font color can be selected whatever you wish from "cell format" option.
=if(or(a1-b1>0,a-b1<0),a1-b1," ")
font color can be selected whatever you wish from "cell format" option.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- SALARY CAN BE CAPITALIZE
- GST Intimation due to Government took possession of Business Premises under PPE Act
- TDS on Fixed Assets purchased
- TDS on purchase of under construction property from a reseller
- Non filing of I T Returns
- GST on Renting godown to KFCSC for Storage of Raagi
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
