Is there a way to not get a #N/A when a lookup in invalid. I would rather have a -0- appear? Glen
G Glen Disteafno Oct 27, 2006 #1 Is there a way to not get a #N/A when a lookup in invalid. I would rather have a -0- appear? Glen
N Niek Otten Oct 27, 2006 #2 =IF(ISNA(YourFormula),"-0-",YourFormula) -- Kind regards, Niek Otten Microsoft MVP - Excel | Is there a way to not get a #N/A when a lookup in invalid. I would | rather have a -0- appear? | Glen
=IF(ISNA(YourFormula),"-0-",YourFormula) -- Kind regards, Niek Otten Microsoft MVP - Excel | Is there a way to not get a #N/A when a lookup in invalid. I would | rather have a -0- appear? | Glen
