[quote=Claus Busch;1599708]Hi Stu,

Am Mon, 12 Mar 2012 02:18:49 +0000 schrieb stu28:

Also does excel allow a number of formulae in a single cell ?
for example ;

=ISNUMBER(SEARCH("X",D2:D50)) [if true then]

=ISNUMBER(SEARCH("AF",B2:B50)) [if true then]

=CHOOSE(COUNT(SEARCH({"SP","HA","PA"},C2:C50)),"ON E"," TWO","THREE")

what do you want to do?
You could work with nested IF formulas, but in your case you will only
get the result of the first true condition. The other conditions will
not be shown. Or you have to combine the IF-statements with OR or AND.
But if all your conditions have to be true, you can try:
=IF((ISNUMBER(SEARCH("AF",B2))+ISNUMBER(SEARCH("X" ,D2))+(COUNT(SEARCH({"SP","HA","PA"},C2))0))=3,"O K","")


Regards
Claus Busch
--

Thank you for your time claus,

what i am trying to do is search my inventory, i currently have three working formulae , but in separate boxes and wished to combine these. I tried your new formula but it returns a blank cell always. I've tried to modify ;

=IF((ISNUMBER(SEARCH("AF",B2:B50))+ISNUMBER(SEARCH ("X",D2: D50))+(COUNT(SEARCH({"SP","HA","PA"},C2:C50))0))= "ONE","TWO","THREE")

but "THREE'' is always returned. I need both first conditions to be true and the third condition to return a result of "ONE" for one match, "TWO" for two, "THREE" for three and a blank cell for none.

Ideally i would also like a blank cell if either of the first conditions are false.

Again i appreciate your help.

Stu