| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel adding to IF statements together
=IF(AM7="Put"&AN7<K2;$K$2-AN7;AN7-$K$2)*OR(AM7="Call"&AN7K2;AN7-$K$2;$K$2-A
N7) In the above statement, I am attempting to link or add to IF statements together. I want it to to do one thing if AM7="Put" and another command if AM7="Call". When I type this in Excel adds an * before the OR. I am not sure what that is, or if I am using the right command to link these too commands. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I set up multiple if statements in Excel? | Excel Worksheet Functions | |||
| What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) | |||
| Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) | |||
| I have Excel columns with different statements (yes, no; numbers). | Excel Worksheet Functions | |||
Threaded Mode
