Thread: If a cell contains a text (unspicified text) then return thespecified text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Auric__ Auric__ is offline
external usenet poster
  
Posts: 538
Default If a cell contains a text (unspicified text) then return the specified text
rafaeldepp.mrm wrote:

Please help me the following:

A1= ABSDH (for ex.)
B1= STANDARD
C1= (if......) formula

If I have a specified text in A1 for example (absgdjj) then return back
to C1 the specified text otherwise give me what contained in B1

Do you mean something like this?

=IF(A1="your text here",A1,B1)

--
This site is currently under retinkerative buildstruction thingmakery.
Reply With QuoteReply With Quote