xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
Is there a formula I can put in C2 that will give the value of positive one when the prior day/cell in column B is higher and negative one when the when lower than the previous day?
<tbody>
</tbody>
| 7/6/2019 | 1 | |
| 7/7/2019 | 2 | 1 |
| 7/8/2019 | 3 | 1 |
| 7/9/2019 | 2 | -1 |
| 7/10/2019 | 1 | -1 |
| 7/11/2019 | 0 | -1 |
| 7/12/2019 | 5 | 1 |
| 7/13/2019 | 6 | 1 |
| 7/14/2019 | 7 | 1 |
| 7/15/2019 | 8 | 1 |
<tbody>
</tbody>
