Sorry it didnt work. It said there was an error with the formula. Two
questions, do I have the wrong version of excel? and why does this discussion
group not show exactly what the formulas are. For example your formula
writes out: AM7="Put"&amp. Why doesnt it just show the formula that I am
going to enter into the cell?

"bj" wrote:

=if(or(and(AM7="Put",AN7<&$K$2),and(AM7="Call",AN7 $K$2));$K$2-AN7:AN7-$K$2)

"Dubbs" wrote:

For some reason I can't add these two IF statements together

[=IF(AM7="Put"&AN7<$K$2;$K$2-AN7;AN7-$K$2)]
[=IF(AM7="Call"&AN7$K$2;$K$2-AN7;AN7-$K$2)]