| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Help with "IF" function
Hi everyone. I am new and need help. I am clueless with functions. I am trying to write a "IF" function that says........
If R2 equals 000000, NONOUT, or OUT......then it is O&M. If not equal 000000, NONOUT, or OUT......then it is capital. I tried this formula but it does not work: =IF(R20,"capital","O&M") I know it is more to it. Please help and thanks in advance. |
|
#2
|
|||
|
|||
|
Quote:
The above would work if the 000000 is actually a number, if it's text then change it to =IF(OR(R2="000000",R2="NONOUT",R2="OUT"),"O&M","CA PITAL") |
|
#3
|
|||
|
|||
|
Quote:
|
|
#4
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
Hybrid Mode
