You could nest ifs, but it would probably be more efficient (and
easier to debug) if you used something like a vlookup instead.


On Nov 10, 10:53*am, 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 Libraryhttp://www.eggheadcafe.com/tutorials/aspnet/43d6dcbd-c079-4707-8def-7...