Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN FORMULA
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN FORMULA
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN FORMULA
"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", "") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |