I have the following formula that I'm using and can't seem to get it
accomplished. In column "G", I have a list of numbers that I need to
have matched with the following formula and give me the class it falls
under, but I keep getting an error, due to to many functions. I found
out that there is a limit of only 7 nested functions in excel. Is
there a way around this, or am I stuck? Any ideas????

Thanks

Tom

=IF(G2<1,"400",IF(G2<2,"300",IF(G2<4,"250",IF(G2<6 ,"150",IF(G2<8,"125",IF(G2<10,"100",IF(G2<12,"92.5 ",IF(G2<15,"85",IF(G2<22.5,"70",IF(G2<30,"65",IF(G 2=30,"60)))))))))))