Excel Formula Auditing
This query is : Resolved
09 May 2009
How can I check at a glance that all the formulas in a worksheet (whether simetric formula/not)are correctly given or not while I am auditing some calculation in a worksheet? Formula auditing mode (so far as I know) displays the path of the formula given in a particular cell and not that of all the formulas at a time.
09 May 2009
Hi Anirban,
If u want to check formulas in excel sheet, there are two ways.
1 Check 1 cell's formula & then copy it to all cells in row/column that should have same formula.
2 Display all the formulas at one time ( I think this is what u want)- press ctrl+ (the key to the left of 1)
If u want to check formulas in excel sheet, there are two ways.
1 Check 1 cell's formula & then copy it to all cells in row/column that should have same formula.
2 Display all the formulas at one time ( I think this is what u want)- press ctrl+ (the key to the left of 1)
10 May 2009
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
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- TDS U/S. 194NF
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Donation Receipt u/s 80G
- MIS MATCH OF INVOICE NUMBER
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
CAclubindia
