IF/AND/OR Functions HELP

[Kreese11]

Good Morning. I’m having a hard time writing a formula. Every time I do it get it kicked back so I needed some additional help from people. I am attempting to write a function that states if a person is located in the USA and hit their target of 0% or higher they get 10 points. If not then they get zero points. I thought the formula should be written like this:=IF(B3=”USA”,(AND (M3=>0%,10,0)))[TABLE="width: 500"]<tbody>[TR][TD]Name[/TD][TD]Country[/TD][TD]Score[/TD][TD]Target[/TD][TD]Variance[/TD][TD]Points[/TD][/TR][TR][TD]Eric[/TD][TD]USA[/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl64, width: 64, align: right"]29.09%[/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl66, width: 64, align: right"]30.98%[/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl66, width: 64, align: right"]-6.10%[/TD][/TR]</tbody>[/TABLE][/TD][TD]0[/TD][/TR][TR][TD]Maria[/TD][TD]USA[/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl66, width: 64, align: right"]30.67%[/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl65, width: 64, align: right"]27.77%[/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl65, width: 64, align: right"]10.46%[/TD][/TR]</tbody>[/TABLE][/TD][TD]10[/TD][/TR][TR][TD]Johanna[/TD][TD]CAN[/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl66, width: 64, align: right"]37.08%[/TD][/TR][TR][TD="class: xl66, width: 64, align: right"][/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl65, width: 64, align: right"]35.95%[/TD][/TR]</tbody>[/TABLE][/TD][TD][TABLE="width: 64"]<tbody>[TR] [TD="class: xl65, width: 64, align: right"]3.14%[/TD][/TR]</tbody>[/TABLE][/TD][TD]0[/TD][/TR]</tbody>[/TABLE]So for example, if cell M3 is 2% then the person would get 10 points. However, my formulas keep producing FALSE in the cells. Can someone please help me out with why this keeps happening?Thank you in advance.

 

[vogel997]

[TABLE="width: 314"]
<colgroup><col width="418" style="width: 314pt; mso-width-source: userset; mso-width-alt: 15286;"> <tbody>[TR]
[TD="width: 418, bgcolor: transparent"]Try this[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]=IF(AND(B3="USA",M3>=0%),10,0)[/TD]
[/TR]
</tbody>[/TABLE]