View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Send Object Command - Two attachments Send Object Command - Two attachments is offline
external usenet poster
 
Posts: 10
Default Stupid If statement question....

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....