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)]

"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)]


Also, why does this discussion board change my formula? I cut and pasted
the formula from the cell but when it appears on this dicussion board it
writes out quot for " ". How can I post my formula exactly the way I have it
in my excel fille?

One way:

=ABS($K$2-$AN$7)*(1-2*(AM7="Call"))



In article ,
"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)]

=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)]

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)]

The discussion board distorts the formula and I can't decipher it. When I
hit reply to this message the format of the formula went back to how it
should read. I copied and pasted
=if(or(and(AM7="Put",AN7<&$K$2),and(AM7="Call",AN7 $K$2));$K$2-AN7:AN7-$K$2)
but it said there is a problem with the formula

"Dubbs" wrote:

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)]

"Dubbs" wrote in message
...

"Dubbs" wrote:

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)]

The discussion board distorts the formula and I can't decipher it. When I
hit reply to this message the format of the formula went back to how it
should read. I copied and pasted

=if(or(and(AM7="Put",AN7<&$K$2),and(AM7="Call",AN7 $K$2));$K$2-AN7:AN7-$K$2)
but it said there is a problem with the formula

Try:
=IF(OR(AND(AM7="Put",AN7<$K$2),AND(AM7="Call",AN7 $K$2)),$K$2-AN7,AN7-$K$2)
--
David Biddulph