Adding to IF statements

[Dubbs]

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]

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?

 

[JE McGimpsey]

One way:

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

 

[bj]

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

 

[Dubbs]

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?

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

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]

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

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?

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

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

 

[David Biddulph]

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?

:

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

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)