Formula to replace "#N/A" with 0
Solved/Closed
Related:
- Formula to replace "#N/A" with 0
- Can the formula COUNTA / COUNT exclude 0 values? ✓ - Forum - Excel
- How to replace * with / in all formulas in an excel sheet ✓ - Forum - Excel
- Formula to Find&replace blank cells in excel ✓ - Forum - Programming
- Replace 'sheet' reference in a formula (not copy data, but get averages) ✓ - Forum - Excel
- 192 l.168.0.1 - Guide
1 reply
rizvisa1
Jul 14, 2010 at 07:26 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 14, 2010 at 07:26 PM
you have to use iserror
=IF(ISERROR(VLOOKUP(..), 0, VLOOKUP(...))
=IF(ISERROR(VLOOKUP(..), 0, VLOOKUP(...))
Jul 14, 2010 at 08:27 PM
I want to add all transaction between 7/10 and 7/12
7/10 - 100
7/11 - 0
7/11 - 100
7/12 - 100
as my vlookup pulls in each date, I only get 200 since it just pulls in the $0 for 7/11.
Jul 18, 2010 at 09:20 AM
Jul 20, 2010 at 09:24 PM