Posted to microsoft.public.excel.worksheet.functions

dvya

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple function is it even possible	Kris M	Excel Worksheet Functions	7	November 22nd 08 09:57 PM
Multiple IF function (maybe OR)	mpenkala	Excel Worksheet Functions	5	January 31st 08 02:22 PM
Multiple IF Function	Roberto	Excel Worksheet Functions	4	March 9th 07 08:20 PM
Multiple results from multiple criteria using IF function	David Platt	Excel Discussion (Misc queries)	2	January 15th 07 10:19 AM
Multiple Sheet, Multiple Criteria Look-Up Function Help	Dan Oakes	Excel Worksheet Functions	5	December 29th 06 01:37 PM

All times are GMT +1. The time now is 02:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us