I'm trying to put together a formula that will report back on only one option out of four when valid.

1. If F15 is between -0.01 and -25000 result should be 1500

2. If F15 is between -25001 and 50000 should be 1000

3. If F15 is between -50001 and 100000 should be 750

and

4. if F15 is 100000+ = 500

I also wanted it to report 0 if F15 equals 0 or is a +ve number so started the formula with IF(F$15>=0,"",IF.....

Thing is I have four option lines.

So in line one I only want it to return the 1500 if it is less than 0 but not more than -25000 inclusive.

If it's more than -25000 than I need it to show 0 in this line and then put the correct result according to option 2 - 4..

Hope this makes sense.

I thought this was an easy one but just cannot seem to get it to work.

Thanks