Excel
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
27 December 2012
Simple Formula
25
30
TOTAL =SUM(B4:B5) A
But I would Like To Known That If Some One Insert A fig In Formula then How To Known
Eg:
25
30
TOTAL =SUM(B11:B12)+6 B
IF U SEE B THEN AMT 6 HAS BEEN ADDED IN THE FORMULA
HOW TO KNOWN THAT 6 HAS BEEN ADDED IN FORMULA THAT IS =SUM(B11:B12)+6
IN A NUTSHELL ANY FORMULA IS THERE TO KNOWN THAT 6 HAS BEEN ADDED IN THE FORMULA
BECAUSE THIS IS ONLY A SINGLE FORMULA BUT I AM HAVING SHEET WHICH HAS MORE THAN
120 FORMULA SO A QUICK LOOK THAT A FIG HAS BEEN ADDED IN THE FORMULA
HOW TO KNOW ??????????????????
Simple Formula
25
30
TOTAL =SUM(B4:B5) A
But I would Like To Known That If Some One Insert A fig In Formula then How To Known
Eg:
25
30
TOTAL =SUM(B11:B12)+6 B
IF U SEE B THEN AMT 6 HAS BEEN ADDED IN THE FORMULA
HOW TO KNOWN THAT 6 HAS BEEN ADDED IN FORMULA THAT IS =SUM(B11:B12)+6
IN A NUTSHELL ANY FORMULA IS THERE TO KNOWN THAT 6 HAS BEEN ADDED IN THE FORMULA
BECAUSE THIS IS ONLY A SINGLE FORMULA BUT I AM HAVING SHEET WHICH HAS MORE THAN
120 FORMULA SO A QUICK LOOK THAT A FIG HAS BEEN ADDED IN THE FORMULA
HOW TO KNOW ??????????????????
28 December 2012
Just press ctrl+` (i.e. the key below the esc button).
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
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- Difference between Date of Payment and Date of Deduction?
- ITDS U/S.194T of Firm
- Unregistered suppliers utility
- Non-Compliance documents have not been submitted by the contractors debited
- EXPORT COMMERCIAL INVOICE HSN CODE
- GST Rate for Catering Services
- Same demand raised for original as well as rectification request return
- Sale of property held jointly with a non resident Indian
- Bank details not Visible on Traces Portal
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
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
