HEEEYYYLPPPPP with formula please

[adam1993]

I am looking for help with a formula for the following situation...[TABLE="width: 500"]
<tbody>[TR]
[TD]Person A[/TD]
[TD]Person B[/TD]
[TD]-20%[/TD]
[TD]$150[/TD]
[TD]Person B[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Person B[/TD]
[TD]20%[/TD]
[TD]$100[/TD]
[TD]Person A
[/TD]
[/TR]
</tbody>[/TABLE]


I am looking for help in column E. If column C is a negative percentage and column D is between $1 and $200, then I would like column E to show whatever is in column B.
AND the opposite...
If column C is a positive percentage and column D is between $1 and $200, then I would like column E to show whatever is in column A.

Please help

 

[Robby19]

Try;

=if(and(C2<0,D2>=1,D2<=200),B2,if(and(C2>=0,D2>=1,D2<=200),A2,""))

Off the top of my head.

 

[FDibbins]

Shortening Robby's suggestion slightly...
=if(and(C2<0,D2>=1,D2<=200),B2,A2)

 

[Robby19]

Shortening Robby's suggestion slightly...
=if(and(C2<0,D2>=1,D2<=200),B2,A2)

Yea...you right. There would be no need for the nested if since the second parameter is just the opposite of the first.

 

[jtakw]

Yea...you right. There would be no need for the nested if since the second parameter is just the opposite of the first.

Hi,

May be, may be not, what if the C value is 0? Unless OP considers that a "Positive".

 

[FDibbins]

I thought about that too, but decided to wait to see if OP had any thoughts on that