If formula

[AbrahamGluck]

I want a formula associated with IF using
in E6 I have a negative or positive currency number, and in F6 I have another negative or positive currency number
I want to formulate in G6 if E6 is equally or less then have of F6 should resulting Good if not should resulting 0

for example F6 is -$3.00 if E6 is anything between-$1.50 to -$0.00 is true anything else (could possibly be between -$4.00 to -&1.51) is false

 

[AbrahamGluck]

this is in cell G6 =IF(F6<0,IF(AND(E6<=0,E6>=F6/2),"WIN",0),IF(AND(E6>=0,E6>=F6*1.5),"WIN",0))

I would like to this differently and more advanced, for example H6 will have a percentage number between 1% to 99%, and G6 will look it up and if its 50% then E6>=F6/2 will resulting "WIN" if the persent in H6 is something else should the WIN rate resulting be different as well,
and the same for the positive numbers if its 50% then will the win rate be resulting for 1.5 if its 25% then 1.25 etc.

 

[AbrahamGluck]

OK, try this instead:

=IF(F6<0,IF(AND(E6<=0,E6>=F6/2),"Good",0),IF(AND(E6>=0,E6>=F6*1.5),"Good",0))

Hi Scott check my new question on this topic please

 

[Scott Huish]

I'm not sure I understand your question.

If G6 is 50% then it checks to see if E6 > = F6/2, and if so WIN, and everything after that I don't get. Can you post a sample and expected results?

 

[AbrahamGluck]

I'm not sure I understand your question.

If G6 is 50% then it checks to see if E6 > = F6/2, and if so WIN, and everything after that I don't get. Can you post a sample and expected results?

Win/Loss Column is looking up if column Total met the Expectation column or better than Expectation column if yes the answer is "WIN", if not the results is a percentage of the Paid column, and its depends in positive number or negative

Total	Paid	Win/Loss %	Expectation
-1.50	-3.00	WIN	50%
+1.88	+1.50	WIN	25%
+1.88	+1.50	25%	50%
-1.89	-3.00	37%	50%

<tbody>
</tbody>

 

[Scott Huish]

Where do the 25% and 37% come from? 1.50 is approximately 79% of 1.88, not 25%

 

[AbrahamGluck]

Where do the 25% and 37% come from? 1.50 is approximately 79% of 1.88, not 25%

1.50 + 25% of 1.50 = 1.875 (rounded 1.88)

 

[Peter_SSs]

1.50 + 25% of 1.50 = 1.875 (rounded 1.88)

Using the same logic for the first row in post #14:
-3 + 50% of -3 = -4.5
-1.5 >= -4.5 therefore "WIN" per your example.

Now apply that same logic to the last sample row in post #14:
-3 + 50% of -3 = -4.5
-1.89 >= -4.5 so why isn't that result "WIN" too?

 

[trolleylabour424]

Actually, I think will work:

=IF(MEDIAN(0,F6/2,E6)=E6,"Good",0)

Although I think your revised question looks identical to your original question.

Worked for me. Thanks