formula issue?

[RUSSELLCLEWS]

Hi there. Please can anyone help? Im trying to display the work "Blue" in a cell if two other cells say the word "Standard" I have this formula but cant seem to get it right?

=IF((AND(ISNUMBER('SEARCH'("BLUE",H8 "BLUE",I8)),"STANDARD","")

Can anyone correct me on this?

Thanks in advance..

 

[mohadin]

B1 conditional formatting formula

=IF(A1="Ohlins",1,0)

 

[Peter_SSs]

B1 conditional formatting formula

=IF(A1="Ohlins",1,0)

.. or more simply B1 conditional formatting formula

=A1="Ohlins"

 

[RUSSELLCLEWS]

.. or more simply B1 conditional formatting formula

=A1="Ohlins"

Thank you again!!!

 

[Peter_SSs]

You're welcome. Glad we could help.

 

[RUSSELLCLEWS]

Hi all,

Please could someone correct me on the following formula?

=IF(ISNUMBER(SEARCH("STEALTH",D8)("B",E11)),"BLACK WHEEL SET - BLACK HUBS ","")

I am trying to display "BLACK WHEEL SET - BLACK HUBS" in the cell I am on but only if cell D8 says "STEALTH" and cell E11 says "B"

The following formula works fine for just D8:

=IF(ISNUMBER(SEARCH("STEALTH",D8)),"BLACK WHEEL SET - BLACK HUBS ","")

but I need to include the E11 now?

Any help would be great, thanks in advance...

 

[Peter_SSs]

am trying to display "BLACK WHEEL SET - BLACK HUBS" in the cell I am on but only if cell D8 says "STEALTH" and cell E11 says "B"

Sounds like it should be one of these

=IF(AND(D8="STEALTH",E11="B"),"BLACK WHEEL SET - BLACK HUBS","")

=IF(AND(ISNUMBER(SEARCH("STEALTH",D8)),E11="B"),"BLACK WHEEL SET - BLACK HUBS","")

 

[RUSSELLCLEWS]

THANK YOU PETER.

 

[Peter_SSs]

You're welcome. Glad to help.