CajunDragon 0 Posted June 21, 2009 Share Posted June 21, 2009 Calling all nerds (ok I'm one too),I have a large column in excel that I track my P&L with. I'd like to calculate my average win and average loss. Any of you have a formula for this? Basically if its a NEGATIVE number it needs to go to the loss formula and if its a POSITIVE number it needs to go to the win formula. I could separate my P&L in to separate loss/win columns but I'm sure there must be a more elegant way to do it without having to unformat the data like that.EXAMPLE of how the P&L is organized: NET-$199.00 $340.00 $420.00-$180.00 $659.00 $570.00-$150.00 Link to post Share on other sites
Chet Chetterson 0 Posted June 21, 2009 Share Posted June 21, 2009 The easy way is to have two columns, one for Profits and the other for Losses then take the average of each. Keeping everything in a same column you'll probably need an IF statement within the AVERAGE command.Event Profit Loss Link to post Share on other sites
Solar 0 Posted June 22, 2009 Share Posted June 22, 2009 you could always use a spread sheet someone else has already made.http://www.fullcontactpoker.com/poker-foru...showtopic=93631 Link to post Share on other sites
CajunDragon 0 Posted June 22, 2009 Author Share Posted June 22, 2009 Thanks for the link. I think I will! Or just copy some of their code in to mine. I spent so much time on my sheet that I don't want to murder it quite yet. Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now