PC Review


Reply
 
 
lightbulb
Guest
Posts: n/a
 
      5th Jan 2010
If I'm in cell C5, I want a formula that will do the following; if cell B5
contains "Assembly" anywhere in it's text, then I want C5 to say Assembly,
otherwise I want C5 to copy B5.

Any help?
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      5th Jan 2010
=IF(ISNUMBER(SEARCH("Assembly",B5)),"Assembly",B5)
--
David Biddulph

"lightbulb" <(E-Mail Removed)> wrote in message
news0D5AC54-D6DD-4C88-B36C-(E-Mail Removed)...
> If I'm in cell C5, I want a formula that will do the following; if cell B5
> contains "Assembly" anywhere in it's text, then I want C5 to say
> Assembly,
> otherwise I want C5 to copy B5.
>
> Any help?



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      5th Jan 2010
Check your other post.

lightbulb wrote:
>
> If I'm in cell C5, I want a formula that will do the following; if cell B5
> contains "Assembly" anywhere in it's text, then I want C5 to say Assembly,
> otherwise I want C5 to copy B5.
>
> Any help?


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Content Placeholder in nested master content page John Microsoft ASP .NET 2 15th Jan 2008 11:48 AM
Master-Content in Asp.net - How to set individual Head for each content page Rolf Welskes Microsoft ASP .NET 7 22nd Aug 2006 03:47 PM
limit on number of content placeholders(which are editable in content pages) in master page nemesis.saurabh@gmail.com Microsoft ASP .NET 0 25th May 2006 05:44 AM
error: Only Content controls are allowed directly in a content page that contains Content controls. hazz Microsoft ASP .NET 2 27th Apr 2006 06:32 PM
checking file content and move to another dir files with same content Matthieu Microsoft Windows 2000 CMD Promt 2 30th May 2005 07:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:24 PM.