Formula Question

[pepschnops]

I need to make a formula that satisfied the following logic:
If F7 is less that 100,000 F7 equals 250
If F7 is greater than 100,000 but less than 500,000 F7 equals 537
If F7 is greater than 500,000 F7 equals 750

I tried making a formula but im useless...
=IF(F7<100,000,F7=250,F7>100000<500,000,F7=537,F7>500,000,F7=750

Any help on this would be greatly appreciated.

Thanks,

Matt

 

[Ruddles]

So if F7 is greater than 500,000 then you make it equal to 750. But now it's less than 100,000 so you have to make it equal to 250.

So just put 250 in F7 because whatever you put in, it will always end up as 250!

Seriously though, put this in a cell - but not F7:-

=IF(F7<=100000,250,IF(F7<=500000,537,750))

(You don't say what value you want if F7 is exactly 100,000 or 500,000 so I've made an assumption.)

 

[VoG]

If you put that formula in F7 you'll create a circular reference. Try in a different cell

=LOOKUP(F7,{0,100000,500000},{250,537,750})