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

Name	Country	Score	Target	Variance	Points
Eric	USA	29.09% <tbody> </tbody>	30.98% <tbody> </tbody>	-6.10% <tbody> </tbody>	0
Maria	USA	30.67% <tbody> </tbody>	27.77% <tbody> </tbody>	10.46% <tbody> </tbody>	10
Johanna	CAN	37.08% <tbody> </tbody>	35.95% <tbody> </tbody>	3.14% <tbody> </tbody>	0

<tbody> </tbody>

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]

Try this

=IF(AND(B3="USA",M3>=0%),10,0)

<colgroup><col width="418" style="width: 314pt; mso-width-source: userset; mso-width-alt: 15286;"> <tbody> </tbody>