Excell Formula
This query is : Resolved
10 May 2009
IT IS 'ISERROR'
IsError function can be used to check for error values.
The syntax for the IsError function is:
IsError( value )
Often times your spreadsheet contains a large amount of formulas which will not properly calculate when an error is encountered. The IsError function, in combination with the If function, can be used to default a cell's value when an error is occurred. This allows your formulas to evaluate properly without your intervention.
IsError function can be used to check for error values.
The syntax for the IsError function is:
IsError( value )
Often times your spreadsheet contains a large amount of formulas which will not properly calculate when an error is encountered. The IsError function, in combination with the If function, can be used to default a cell's value when an error is occurred. This allows your formulas to evaluate properly without your intervention.
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
- CLOSING STOCK QUERY
- Exiting partner in partnership firm in gst portal
- TDS _Long term Capital Gain ref.sec 214 Table 2
- Traces submitting correction statement error
- NRI INSURANCE ADVISOR
- Missed TDS
- IT returns for fresh job holders
- F&O reporting in ITR
- Applicability of Books of Account for Commission Income (Sections 194D & 194H)
- Gst on travel by air for business purposes
- DUE DATE FOR ITR FILING
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
- FEMA/RBI treatment — Amazon.ca arbitrage (US buy, Canada sell, goods never enter India)
- Goods return by customer
- INWARD REMITTANCE FOREIGN
- CPC and SAC
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
