Hello guys,
I have a list of securities which refreshes everytime.
So I want to calculate the share price return in column J. In column J you can see for example the calculation for Arreal Bank and Arreal Bank CFD in row 51 and row 52, which should not be. It should just show the calculation of Arreal in row 51 with 5%.
Then in row 58-61 I have the main equity and the CFD and some Options, so in column J it should take only the main equity in account.
And then there is also the case, that the CFD is alone, then it should show the calculation.
Does anybody have a solution for that? I think with the IF function, but don't know how to include or exclude when cases above show up.
Bookmarks