if / substitue ???

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Cells:
(1) (2) (3)
001 1 document XXX
002 1 reserved for XXX

If column contains the word 'reserved' I want column 2 to
display "-" (these columns are generated from other
columns not hand typed).

I've tried various different functions and can't quite get
it right, can anyone help me please.
Thanks,
Emma
 
Emma

if the data starts in row 1 then, in cell B1, put the following formula:

=IF(LEFT(C1,8)="reserved","-","")

Drag down as far as you need to.

Regards

Trevor
 
<<"(these columns are generated from other columns not hand typed).">>

By this, do you mean that the "1" in column 2 of your example is the result
of some formula *already* existing in column 2?

If that be the case, you should post the existing formula so that any
suggestions you receive here will not disrupt your already calculated
returns.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Cells:
(1) (2) (3)
001 1 document XXX
002 1 reserved for XXX

If column contains the word 'reserved' I want column 2 to
display "-" (these columns are generated from other
columns not hand typed).

I've tried various different functions and can't quite get
it right, can anyone help me please.
Thanks,
Emma
 
okay it goes ilke this:
A7 contains: =AD7&"-"&AE7&"-"&AF7&"-"&AG7
B7 contains: =AH7
C7 contains: =AI7


If AH7 contains a zero & AI7 contains the word 'reserved'
anywhere in the sentence I need B7 to show '-'.

B7 already contains maximum conditional formats so I need
it to be added into the existing formulae '=AH7' if
possible.

Sorry if it wasn't clear the first time.
Any help would be really appreciated, thanks.
Emma
 
If I understand what you're asking, try this in B7:

=IF(AND(AH7=0,NOT(ISERR(SEARCH("reserved",AI7)))),"-",AH7)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



okay it goes ilke this:
A7 contains: =AD7&"-"&AE7&"-"&AF7&"-"&AG7
B7 contains: =AH7
C7 contains: =AI7


If AH7 contains a zero & AI7 contains the word 'reserved'
anywhere in the sentence I need B7 to show '-'.

B7 already contains maximum conditional formats so I need
it to be added into the existing formulae '=AH7' if
possible.

Sorry if it wasn't clear the first time.
Any help would be really appreciated, thanks.
Emma
 
Back
Top