To clarify, I would like my formula to reside in column (B), but there is
other info already in that column. If the condition in column (A) is met,
then (B) must change, otherwise not.

"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!