View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
glenn glenn is offline
external usenet poster
 
Posts: 122
Default Trouble with an IF formula

I have an IF formula which selects a date (in text format) and, if the
criteria is met, will perform a calculation. It works fine except it returns
a value error when the date I'm looking for isn't in the field. I'm looking
to have it return 0 instead of value.