if limitation

[white_flag]

hello I have an formula like this:

=IF(K54="15";30;IF(K54="25";30;IF(K54="32";40;IF(K54="50";40;IF(K54="65";50;IF(K54="80";50;IF(K54="100";60;IF(K54="125";60;"no values"))))))))

but I need to insert more IF conditions. If I put extra then I received an error (I think that it is the limit). Can I"trick" this limit some how?

 

[Andrew Poulsom]

Use a lookup table:

http://www.contextures.com/xlFunctions02.html

 

[white_flag]

correct ..thx mate