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" 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 columnNext: repeat code remove