[TABLE="class: grid, width: 500, align: left"]

<tbody>[TR]

[TD]A[/TD]

[TD]B[/TD]

[TD]C[/TD]

[TD]D[/TD]

[TD]E[/TD]

[TD]F[/TD]

[/TR]

[TR]

[TD]Odds[/TD]

[TD]Won/Lost[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]1.865[/TD]

[TD]0[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]1.733[/TD]

[TD]1[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]1.644[/TD]

[TD]1[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]1.380[/TD]

[TD]0[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]2.051[/TD]

[TD]0[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD]Percentage won[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

</tbody>[/TABLE]

in column A I have list of odds, in columnd B: 1/0 for won/lost, what I need to calculate is percentage won for each band of odd (e.g 1.00-1.49, 1.5-2 and >2

so I supposes there needs to be two IFs, if A is <1.5 and is 1 then it returns 1, if it's 0 then return 0, but if it's more than 1.5 ignore it, than in column D would be 1.5-1.99, and would return 1, if B is 1 and A is between 1.5-1.99 etc.

hope you can understand what I'm trying to to, I'm not great in explaining these things

thanks for your help