Oops! The upper limit should be 5%, not 4%. :~

=MEDIAN(1,INT(A1/50000-3),5)/100

--
Dana DeLouis


"Jim Rech" wrote in message ...

The problem with this solution, Dana, is that only 5 people in the world
understand it.<g

--
Jim
"Dana DeLouis" wrote in message
...
| I have 5 conditions in an IF formula
|
| Hi. Not sure want you want if it's below 200,000 but this idea sets it at
your floor of 1%
|
| =MEDIAN(1,INT(A1/50000-3),4)/100
|
| --
| HTH :)
| Dana DeLouis
|
|
| "Kirk" wrote in message
...
| Hi,
|
| I have 5 conditions in an IF formula and I just cant get it right. Im
trying
| to display a % in cell D10.
| D10 must display 1% if F12 has the value between 200000 and 249999.
| D10 must display 2% if F12 has the value between 250000 and 299999.
| D10 must display 3% if F12 has the value between 300000 and 349999.
| D10 must display 4% if F12 has the value between 350000 and 399999.
| D10 must display 5% if F12 has the value is 400000 and above.
|
| Thanks,
| Kirk
|