combine multiple options IF(OR(ISNUMBER

Hi,

I have the A1 which is either a cable, an adapter, a mouse or a notebook. I'd like to get the category "accessory" if it's a cable/adapter or a mouse.
I've tried the following formula but it doesn't work:

=IF(OR(ISNUMBER(SEARCH("cable","adapter","mouse";a1)));"accessory";"")

Any tip what the issue is? May be the separator settings?

Thanks,
Divi

If there is other text in the cell another option

Formula:

Please Login or Register  to view this content.

If you've given us a complete description then it sounds like you just need:

=IF(A1="notebook";"notebook";"accessory")

A bit cheeky to follow on from the OP but I have a different but similar question

I have a time value in B2. If the time value in A2 changes, then B2 must also change. The value in B2 is 10:57. If 11:05 is manually inputted to A2, then B2 must change to 7:24. If A2 is left blank, then B2 should read 10:57
I'm using B2=IF(ISNUMBER(SEARCH("11:05",A2)),C2,D2) where C2 is 7:24 and D2 is 10:57

But it isn't working. All advice gratefully accepted!
.

Hi Glenn

I just wanted to apologise - I can only plead ignorance. I have followed all your instructions and I will now, as a suitably contrite user, wait with bated breath.....