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.

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

Do you know why this dicussion group changes "Put" to "Put&quot? I didnt
write it out like that.

"Bill Martin -- (Remove NOSPAM from addre" wrote:

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

Dubbs wrote:
Do you know why this dicussion group changes "Put" to "Put&quot? I didnt
write it out like that.

"Bill Martin -- (Remove NOSPAM from addre" wrote:


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

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

I don't see it like that anywhere in your original note, so it's
probably some function of the program you're using to read it. It
sounds like what you're seeing is an html tag being rendered as plain
text perhaps?

Bill