try:
=IF(OR(D13="Necking",D13="Caution",d13="Fracture"),"Caution"," ")

"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.
> Now i also want to include the word Fracture in the formula, so when my
> table shows the word Fracture, the word Caution will appear in the cell next
> to it as well.
>
> is there anyway i can simply put the word "Fracture" into the formula?