Hi there. I am new to the forum and also new to excel. If anybody could please help me with a formula that would solve my problem, I would really appreciate it. I have tried certain range of the IF, AND, as well as OR functions but was still not able to get the results I am looking for. For the sake of argument:

if A1 is between 1 and 25, the value in B1 should be 2500
if A1 is between 26 and 50, the value in B1 should be 5000
if A1 is between 51 and 75, the value in B1 should be 7500
if A1 is between 76 and 100, the value in B1 should be 10000
if A1 is between 101 and 125, the value in B1 should be 12500
if A1 is between 126 and 150, the value in B1 should be 15000
if A1 is between 151 and 175, the value in B1 should be 17500
Etc

What formula can I use?