I am looking for help with a formula for the following situation...
<tbody>
</tbody>
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
Person A | Person B | -20% | $150 | Person B |
Person A | Person B | 20% | $100 | Person A |
<tbody>
</tbody>
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