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

 

[seguin85]

I think this is what you are going for:

=IF(AND(E6<=0,E6>=-1.5),-3,"False")

 

[Joe4]

I want to formulate in G6 if E6 is equally or less then have of F6 should resulting Good if not should resulting 0

Not quite clear if this is what you want, but do you mean something like this (in cell G6):

=IF(E6<=F6,"Good",0)

 

[Scott Huish]

Perhaps:

=OR(E6=0,AND(ABS(E6)>0,ABS(E6)<=(F6/2),SIGN(E6)=SIGN(F6)))

 

[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

I have a change in the question, sorry for the mistake in the first place.

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 "half" 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]

Not quite clear if this is what you want, but do you mean something like this (in cell G6):

=IF(E6<=F6,"Good",0)

Thank you, see I have changed up the question.

 

[Scott Huish]

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.

 

[AbrahamGluck]

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.

Thanks Scott! that works perfectly for this negative situation!
For a positive situation I would want it differently, this will not work for it, for example if F6 is positive $3.00 then the good situation will be if E6 is 1 1/2 times F6 anything more or equal to $4.50 anything less then $4.49 is false or 0

 

[Scott Huish]

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))

 

[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))

Thanks Scott! This is reall perfect and helps me a lot!
how can I mark it answered?