automatic selecting the highest cell

K

kimare

I'm sorry for being a bit confusing, I did even manage to confus
myself, as I gave you wrong directions.

Now I've uploaded a picture of my spreadsheet, so hopefully you'r
fully able to understand what I want to do.

First I would like to explain what this is this is at speardsheet fo
value betting.

Column B:D are my percentage evaluation for the outcome of an match.
Column F:H are odds generated of my evaluation.
Column J:L are the bookmakers odds for the same matches
Column N:p are the given value (difference between my and th
bookmakers odds) a value over 100% indicates that this is a game tha
might pay you back.

Column Q indicates if you made the right choice "j"=yes/"n"=no
Column R are my stake unit
Column S are my gain
Column T are my profit percentage

What I would like are the following formula in Column S:
IF Q are "j" then R multiply with the right Column J:L. This ar
determined by the highest value of Column N:p, but only if the valu
are higher than 110%. And if "n" I'll get no gain and therefore th
value in Column S are set to 0. If Coulum R are "blank" I have not mad
any bets on this match, therefore Column S also becomes blank.

Hopefully I've managed to explain myself good enough. :)

thanks
Ki

+-------------------------------------------------------------------
|Filename: verdi web.jpg
|Download: http://www.excelforum.com/attachment.php?postid=2781
+-------------------------------------------------------------------
 
Top