View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anna McKenzie Anna McKenzie is offline
external usenet poster
 
Posts: 1
Default If then statement

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