Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add two IF statements together
I am trying to add these two together but can't get it to work.
=IF(AM11="Put"&AN11<$K$2;AN11-$K$2;$K$2-AN11) =IF(AM11="Call"&AN11$K$2;$K$2-AN11;AN11-$K$2) |
#2
|
|||
|
|||
I assume by the ampersand you mean "AND". There's a function for that.
Ampersand concatenates text. Assuming AM11 will contain only Put or Call, and no other values, and the result is to be negative for Puts and positive for Calls, =IF(AM11="Put",-ABS(AN11-$K$2),ABS(AN11-$K$2)) or =ABS(AN11-$K$2)*IF(AM11="Put",-1,1) On Tue, 14 Jun 2005 10:07:07 -0700, "Dubbs" wrote: I am trying to add these two together but can't get it to work. =IF(AM11="Put"&AN11<$K$2;AN11-$K$2;$K$2-AN11) =IF(AM11="Call"&AN11$K$2;$K$2-AN11;AN11-$K$2) |
#3
|
|||
|
|||
I am not sure why it shows my formulas like that. It should read
=IF(AM11="Put"&AN11<$K2$;AN11-$K$2;$K$2-AN11) and =IF(AM11="Call"&AN11$K$2;$K$2-AN11;AN11-$K$2) "Dubbs" wrote: I am trying to add these two together but can't get it to work. =IF(AM11="Put"&AN11<$K$2;AN11-$K$2;$K$2-AN11) =IF(AM11="Call"&AN11$K$2;$K$2-AN11;AN11-$K$2) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 7 IF statements in one arguement | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
If statements | Excel Worksheet Functions |