Combine: ISNUMBER(SEARCH( and EXACT( ?
 

Hi, trying to combine these two items, have the following that does not seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Answer: Combine: ISNUMBER(SEARCH( and EXACT( ?
 

Hi there! It looks like you're trying to combine the functions ISNUMBER(SEARCH() and EXACT() in your Excel formula. Here's how you can do it:

1. The SEARCH function looks for the text "Test" within the cell CI9. If "Test" is found, SEARCH returns the starting position of the text. If "Test" is not found, SEARCH returns the #VALUE! error.
2. The ISNUMBER function checks whether SEARCH returns a number (i.e. the starting position of "Test" within CI9). If SEARCH returns a number, ISNUMBER returns TRUE. If SEARCH returns an error, ISNUMBER returns FALSE.
3. The EXACT function checks whether the text in CI9 is exactly equal to "Test". If CI9 is exactly equal to "Test", EXACT returns TRUE. If CI9 is not exactly equal to "Test", EXACT returns FALSE.
4. The AND function combines the results of the ISNUMBER and EXACT functions. If both functions return TRUE, AND returns TRUE. If either function returns FALSE, AND returns FALSE.

So the entire formula checks whether the text "Test" is found within the cell CI9 and whether the text in CI9 is exactly equal to "Test". If both conditions are met, the formula returns TRUE. If either condition is not met, the formula returns FALSE.

I hope that helps!

Combine: ISNUMBER(SEARCH( and EXACT( ?
 

Just guessing......
If you want to know if cell CI9 contains the word Test,

Try this:
=COUNTIF(CI9,"*Test*")0
or this
=ISNUMBER(SEARCH("Test",CI9))

But, if you need a case-sensitive search:
=ISNUMBER(FIND("Test",CI9))

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"nastech" wrote in message
...
Hi, trying to combine these two items, have the following that does not
seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Combine: ISNUMBER(SEARCH( and EXACT( ?
 

Use FIND instead of SEARCH it is case sensitive


--


Regards,


Peo Sjoblom




"nastech" wrote in message
...
Hi, trying to combine these two items, have the following that does not
seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Combine: ISNUMBER(SEARCH( and EXACT( ?
 

Not really surprising.
EXACT returns either TRUE or FALSE

So past of your formula will be SEARCH(TRUE,C19)
(or SEARCH(FALSE,C19) )
but the syntax is SEARCH(find_text,within_text,start_num)

Please tell us what you wish to achieve.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"nastech" wrote in message
...
Hi, trying to combine these two items, have the following that does not
seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Combine: ISNUMBER(SEARCH( and EXACT( ?
 

case-sensitive text, within text

"Bernard Liengme" wrote:

Not really surprising.
EXACT returns either TRUE or FALSE

So past of your formula will be SEARCH(TRUE,C19)
(or SEARCH(FALSE,C19) )
but the syntax is SEARCH(find_text,within_text,start_num)

Please tell us what you wish to achieve.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"nastech" wrote in message
...
Hi, trying to combine these two items, have the following that does not
seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))