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
>