Woofy_McWoof_Woof
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
Hi, I'm attempting to create an IF statement that will depend on three potential outcomes and to also split the outcomes into two columns. For instance in the attached picture in row 3 there is a positive position on day one of 5, on day 2 this changes to positive 10, a change of positive 5. Therefore, the change of positive 5 will appear on the statement and 0 will appear on the invoice. The same logic applies to to row 4 even though the position on day 2 is less than day one (but as the position on day 2 is still above zero) so it appears on the statement.
However, in row 5 the position on day one is positive 5 though the position on day 2 is negative 10, a change of negative 15. I need negative 5 to appear on the statement and negative 10 to appear on the invoice.
This logic should apply to all rows and split the volume out accordingly, I have tried to do a few different combinations on IF and AND statements and I can get the logic to work when its either all on the invoice or all on the statement but can't seem to get it to work when the volume should be split across both the statement and invoice.
Any help would be greatly appreciated.
Cheers
However, in row 5 the position on day one is positive 5 though the position on day 2 is negative 10, a change of negative 15. I need negative 5 to appear on the statement and negative 10 to appear on the invoice.
This logic should apply to all rows and split the volume out accordingly, I have tried to do a few different combinations on IF and AND statements and I can get the logic to work when its either all on the invoice or all on the statement but can't seem to get it to work when the volume should be split across both the statement and invoice.
Any help would be greatly appreciated.
Cheers