3.15 IFERROR and IFNA
| Function | Catches | Example |
|---|---|---|
IFERROR(value, value_if_error) |
every error type | =IFERROR(G2/F2,0) |
IFNA(value, value_if_na) (Excel 2013+) |
only #N/A |
=IFNA(XLOOKUP(…),"Not found") |
Worked example. Amount per unit when Qty may be blank: =IFERROR(G2/F2,"Check Qty"). Store lookup: =IFNA(VLOOKUP(A2,Stores!A:F,4,FALSE),"New store – add to master").
Ravindra Bagale's Tip
IFERROR sagle errors lapavto – typo mule aalela #NAME? kiwa column delete mule aalela #REF! suddha! Khup students sagalya formulas la IFERROR laavun khari chuk lapavtat. Lookup sathi IFNA vapra, aani IFERROR fakt jithe error apekshit aahe tithech lava.
Practice task
Calculate Amount/Qty with IFERROR. Look up a store's city with IFNA and show "Missing in master" for unknown store IDs.