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
- Ito add credit side of bank
- Employee secondment
- Clarification on GST, TDS, and Accounting Provisions for Import/Export Commission Agents,profes. ser
- Reward for festival
- Clarification on GST, TDS, and Accounting Provisions for Import/Export
- GSTR9 Annual Return
- Appointment of Auditor By Form ADT-1
- TDS Return Statement Status
- RCM and same line
- Closer of business and itc of capital goods
- Upload Level ValidationITR3Category of Defect B/D
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- MSME Payment Sec.43B (h)
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
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
