IF OR AND help ... I'm lost and maybe have the wrong formula all together.

I need to have points given based off of an "Either Or" scenario. If 15 Items sold or $$15,000, you will receive 10 points; If 20 Items sold or $20,000, you will receive 15 points and If 25 Items sold or $25,000, you will receive 20 points. Here is the formula that I found might work, but it's calculating a result of 10 points regardless if the result is over $25,000.

(Mind you this is only the beginning of the formula)

=IF(OR(D6>=15,D6<=20,AND(I5>=15000,I5<20000))=TRUE,10,"False")

D6 is this formula: =SUMIFS(G8:G57,C8:C57,"Allstate",H8:H57,"Line 10 Auto")+SUMIFS(J8:J57,C8:C57,"Allstate",K8:K57,"Homeowners")+SUMIFS(J8:J57,C8:C57,"Allstate",K8:K57,"Condo")

I5 is this formula:=SUM(R9)

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Sample formula search.xlsx

Here is an example

How about this,

Please Login or Register  to view this content.

It seems better to me! Thank you! However, because we have over 25k in premium in the example, I need it to give 20 points. I'm really not sure how to go about that kind of calculation.

Amended forumla,

Please Login or Register  to view this content.

That works!! Thank you so very much!!

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.