"Alexis" wrote:
> this is my formula for my excel project
> =IF(OR(D13="Necking",D13="Caution"),"Caution"," ")
> This means if the word Necking appears in my table,
> then in the cell next to it so should the word Caution.
That is not exactly what the above formula does. It
results in the word Caution if D13 has Necking __or__
Caution. If you simply want what you wrote, the correct
and sufficient formula is:
=IF(D13 = "Necking", "Caution", "")
Bookmarks