Help with Formula in Open Office .

[trevlyn1983]

Im having Problems with this Formula working and cant figure out why ..

=I3+IF(G4="L";-F4;IF(G4="P";"";IF(G4="W";IF(E4<0;ROUND( F4/(E4/-100);IF(G4="W";IF(E4>0;ROUND(F4*E4/100))))))))

E = Line
F = Bet
G = Win/Loss/Push
I3 = my starting Bankroll .

trying to get this formula to automatically calculate my Bankroll depending on the Line / my Bet / and if i Won or Loss .
Any help would be appreciated .. Prob just overlooking something.

Also it works in calculating if if the line is neg . like -110 , -120 etc .

[trevlyn1983]

I figured it out i think .