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
- ITR filing- non tax audit cases- Asstt.Year 2026-2027
- Soyabean hsn code and gst rate
- Treatment of Pension ?annuity returns on PMVY
- NON- SUBMISSION OF LLP FORM 3
- TDS related Query_Liquidated Damages
- CA IPCC Registeration in 2012, Is my registration Active or Expired
- What is provisional receipt number for generation of form 16A
- AY 26-27 ITR-4 FILING U/S 44-ADA
- Plot of land. Cost of Acquisition
- Free lancer income
- GSTR-4 Annual Return ! Pending Returns for F.Y. 20-21 to 22-23
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR selection for salaries and capital gain less than L
- Showing Gift from relative in ITR for this year
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Small dealers gst returns filing
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
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
