Multiple If Function
Not sure why you're using AND. It's not doing anything.
Try it like this:
=IF(COUNT(SEARCH($F$1,$D4)),IF($C4=F$2,$B4,""),"")
--
Biff
Microsoft Excel MVP
"dvya" wrote in message
...
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
|