Excel adding to IF statements together

[Dubbs]

=IF(AM7="Put"&AN7<K2;$K$2-AN7;AN7-$K$2)*OR(AM7="Call"&AN7>K2;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.

[Bill Martin -- (Remove NOSPAM from address)]

Dubbs wrote:
> =IF(AM7="Put"&AN7<K2;$K$2-AN7;AN7-$K$2)*OR(AM7="Call"&AN7>K2;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,NeitherAction))

Good luck....

Bill

[Dubbs]

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"&AN7>K2;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,NeitherAction))
>
> Good luck....
>
> Bill
>

[Bill Martin -- (Remove NOSPAM from address)]

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"&AN7>K2;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,NeitherAction))
>>
>>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