If then statement
Set up a two-column table somewhere (eg AX1:AY6) as follows:
0 M01
244 M02
313 M03
382 M04
451 M05
520 Too large
Then you can use this formula:
=VLOOKUP(AK11,AX$1:AY$6,2)
Copy it down if required.
Hope this helps.
Pete
On Nov 10, 3:53*pm, 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...
|