Col A Col B
0 M01
243.8 M01
243.9 M02
312 M02
313 M03
381 M03
382 M04
450 M04
451 M05
520 M05

In Cell D1 type =Lookup(C1,A1:B10)
The table acts as ranges for your M0 numbers. The lookup find the actual that
you input into C1 say 427, and the corresponding M0 number is retruned, in
this case it would be M04


Thanks
Matt



Anna McKenzie wrote:
I would like to set up an if then statement incorporating the language below:

If AK11 is <= 243.9 then it is grade M01
If AK11 is =244 but less than 313 then M02
If AK11 is =313 but less than 382 then M03
If AK11 is =382 but less than 451 then M04
If AK11 is =451 but less than 520 then M05

Is this possible. Pls advise.

EggHeadCafe - Software Developer Portal of Choice
XCeed Streaming Compression Library
http://www.eggheadcafe.com/tutorials...compressi.aspx

--
Matt Lynn

Message posted via http://www.officekb.com