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