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
- DELIVERY GOLD & SILVER AND OTHER ETF TRADING PROFIT AS BUSINESS INCOME
- GSTR-1A How to update Invoice
- Excess salary payment.
- 3cd- cash system of accounting is allowed?
- Provision for loans that are under Revenue Recovery
- Form 121-contradictory opinions
- APPLICABILITYOF GST ON STUDENT HOSTEL FEES
- Capital gain from sale of house property
- Is Personal Guarantee of Director is Compulsory in case of loan to company ??
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- Sale Incentive booking
- Negative ITC in Table 4(A)(5)
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
