Hi

You were practically there. This formula is entered in B1
=IF(OR(A1="Dist",A1="Sale"),"'--", "")

Regards

Roger Govier


DTTODGG wrote:
OK guys/gals -

I know this MUST be simple, but I'm very new to excel.
I'm trying to look at one column (A), if the work "Dist" or "Sale" is in the
Cell, I would like to fill the next column (B) with "--", otherwise, leave
the values alone in column B.

=IF(OR(A1="Dist",A1="Sale"),B1="'--", otherwise leave value alone in B1

Thanks for everything!