If statement between numbers

Hi guys,

Trying to figure out what I am doing wrong here. I am trying to had a % increase depending on if a number is between a set. My formula keep solving only my first If statement i have nested. What am i doing wrong? attached the file . Thanks guys

In addition to Sambo kid's post, you need to reverse the order of numbers. As you are using a less than comparison you need to work from the lowest number upwards. For example, your first comparison is 'A3 less than 1500', and your last comparison is 'A3 less than 250', but all numbers less than 250 are also less than 1500. Also, you don't need to include S3+ in every result, just add it at the very start of the formula and then the appropriate result will be added to it.
You might also want to look at using an IFS function instead of nested IF functions just to cut down on the length.

Thanks guys! much appreciated!