Forum Discussion
help with formula while ignoring value errors
Hi all. New user and self taught excel user so bare with me... I've created a table consisting of 2 list columns, one with names and another with hours, and a third column that will automatically p...
You could try surrounding whatever formula you have that is working when there are no #N/A errors....surround that existing formula with the IFERROR function. It will end up looking something like this:
=IFERROR(whatever_you_have_already),0)
That should put a zero in instead of #N/A
If you'd rather a blank space, then
=IFERROR(whatever_you_have_already),"")
If that doesn't make sense, or doesn't work, perhaps you could post a copy of your sheet, just devoid of real names or any other confidential info.
That worked. Thanks a lot!