Prev: adding every other column
Next: repeat code remove
From: dvya on 24 Dec 2009 13:46
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
From: T. Valko on 24 Dec 2009 13:57
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" <dvya(a)discussions.microsoft.com> wrote in message
news:99BD9AC0-DF68-45D9-995D-254C67AFF42C(a)microsoft.com...
> 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


From: Mike H on 24 Dec 2009 14:35
Hi,

Your AND is superfluous, your not 'anding' anything and to eliminate false
add another NULL false condition

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

Mike

"dvya" wrote:

> 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
 | 
Pages: 1
Prev: adding every other column
Next: repeat code remove