IF THEN FORMULA

A

Alexis

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?
 
J

joeu2004

Alexis said:
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.
Click to expand...

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", "")
 
Top