One way:

=IF(F12=400000,5%,IF(F12=350000,4%,IF(F12=30000 0,3%,IF(F12=250000,2%,IF(F12=250000,1%,0)))))

--
Jim
"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
|