Another option is to use vlookup:
=IF(ISBLANK(D2),"-",VLOOKUP(D2,{0,0;1,25;2,50;3,75;4,100;5,125;6,150 ;7,175;8,200;9,225;10,250},2))

Note that ".." should not be wrapped around numbers in formulas as this will
result in text numbers rather than real numbers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nash13" wrote:
I am trying to build a logic statement with 11 arguments. We are using Excel
2003 which I am assuming has a limit on 7 such arguments. I've attached my
formula below, how can I bypass these limits?

Thank you

=IF(D2=10,"250",IF(D2=9,"225",IF(D2=8,"200",IF( D2=7,"175",IF(D2=6,"150",IF(D2=5,"125",IF(D2=4 ,"100",IF(D2=3,"75",IF(D2=2,"50",IF(D2=1,"25",I F(D2=0,"0","N/A"))))))))))