Formula to replace "#N/A" with 0
Solved/Closed
Related:
- Formula to replace "#N/A" with 0
- //192.168.l.0 - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Toshiba factory reset 0 not working ✓ - Laptop Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 14, 2010 at 07:26 PM
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