View Single Post
  #2   Report Post  
Old January 19th 16, 04:39 AM posted to microsoft.public.excel.worksheet.functions
Auric__ Auric__ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
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.