View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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...