View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dvya dvya is offline
external usenet poster
 
Posts: 7
Default Multiple If Function

Im trying to create a report using multiple IF criteria. My formula is
working however how can i get the field to be blank if it doesnt meet the
criteria?

currently if it matches criteria in column C and not column D it is blank
but if it doesnt match column C it sais "FALSE".

=IF(AND(ISNUMBER(SEARCH($F$1,$D4))),IF($C4=F$2,$B4 ),"")

Thank you