hi
I am trying to have a cell calculate the profit or loss of 2 cells based on a Dutching calculation. Dutching basically just means that if either of the 2 selections has W in row V, the profit is the same regardless of which one has the win. If there is a W in either cell, then the following calculation is carried out:-
Now this code works fine by itself, but I want to be able to automate the process whereby the result is input based on what is in row V.
So what I need is the following in English; IF V2 or V3 shows L or P, then the result is -100. If V2 or V3 shows W, then perform the calculation above. Here is what I have tried so far, but with no results:-
I forgot to add that I want the result only to appear in one of the two rows, as otherwise, the profit would be doubled up if it was in row 2 & 3 and so on.
Any thoughts on how to get this to work correctly?
Thanks in advance
I am trying to have a cell calculate the profit or loss of 2 cells based on a Dutching calculation. Dutching basically just means that if either of the 2 selections has W in row V, the profit is the same regardless of which one has the win. If there is a W in either cell, then the following calculation is carried out:-
Code:
=(((1/T2)/(1/T2+1/T3)*98)*T2)-98
Now this code works fine by itself, but I want to be able to automate the process whereby the result is input based on what is in row V.
So what I need is the following in English; IF V2 or V3 shows L or P, then the result is -100. If V2 or V3 shows W, then perform the calculation above. Here is what I have tried so far, but with no results:-
Code:
=IF(AND(V2={"L","P"}),(V3={"L","P"}),-100,(((1/T2) / (1/T2+1/T3)*98)T2)-98
Code:
=IF(AND(OR(V2={"L","P"}),(V3={"L","P”})),-100,IF(OR(V2=“W”,V3=“W”),(((1/T2) / (1/T2+1/T3)*98)T2)-98
I forgot to add that I want the result only to appear in one of the two rows, as otherwise, the profit would be doubled up if it was in row 2 & 3 and so on.
Any thoughts on how to get this to work correctly?
Thanks in advance
Last edited: