Woofy_McWoof_Woof
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
Hi
I am attempting to do an If statement that can give 4 potential results depending on whether the Volume or Value is positive or negative.
For instance in the example below (row 3) I have sold 4.9 units at a price lower than i assumed it would be which cost me -12.84. However, the next day (row 4) I sell 5.5 units at a positive delta price which gives me a benefit of 15.50.
In row 5 i bought 1.7 units at a cheaper rate than i thought i would which gives me a benefit of 8.95 and finally in row 6 i bought 1 unit but it cost me more than I thought it would so it results in a loss of 6.5.
I am able to do an if statement on one way i.e. all gain or all loss but i can't seem to crack it where both gains and benefits are included together.
Any help would be most appreciated.
Thank you.
I am attempting to do an If statement that can give 4 potential results depending on whether the Volume or Value is positive or negative.
For instance in the example below (row 3) I have sold 4.9 units at a price lower than i assumed it would be which cost me -12.84. However, the next day (row 4) I sell 5.5 units at a positive delta price which gives me a benefit of 15.50.
In row 5 i bought 1.7 units at a cheaper rate than i thought i would which gives me a benefit of 8.95 and finally in row 6 i bought 1 unit but it cost me more than I thought it would so it results in a loss of 6.5.
I am able to do an if statement on one way i.e. all gain or all loss but i can't seem to crack it where both gains and benefits are included together.
Any help would be most appreciated.
Thank you.
Row 1 | Col B | Col C | Col D |
Row 2 | Volume | Value | Result |
Row 3 | 4.90 | -12.84 | Loss |
Row 4 | 5.50 | 15.50 | Gain |
Row 5 | -1.70 | -8.95 | Gain |
Row 6 | -1.00 | 6.50 | Loss |