View Single Post
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Dubbs wrote:
=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.


---------------------------

If I understand your intentions correctly, try:

[ ] = IF(AM7="Put",PutAction,IF(AM7="Call",CallAction,Ne itherAction))

Good luck....

Bill