Nested IF Statement

[pedro88]

Hi,

I'm trying to manual calculate an adjusted cost base from a large list of stock transactions for different securities


=IF(A3=A2,IF((E3="BUY",J2+I3,IF(IF(E3="SELL",J2-(F3*L2),I3)

I'm trying to use the above formula but it keeps returning "false" instead of I3 when a3 does not equal a2

I also tried adding an AND at the beginning but this didn't seem to work, any help is greatly appreciated

Thanks,
Pedro

 

[pedro88]

This seemed to work:

=IF(AND(A3=A2,E3="BUY"),J2+J3,IF(AND(A3=A2,E3="sell"),J2-(F3*L2),I3))