If then statement

  • Thread starter Thread starter Anna McKenzie
  • Start date Start date
A

Anna McKenzie

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/tutorial...f-769ec7085cf2/xceed-streaming-compressi.aspx
 
Anna said:
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/tutorial...f-769ec7085cf2/xceed-streaming-compressi.aspx
Click to expand...


=LOOKUP(AK11,{0,243.9,313,382,451,520},{"M01","M02","M03","M04","M05","Undefined"})
 
Glenn said:
=LOOKUP(AK11,{0,243.9,313,382,451,520},{"M01","M02","M03","M04","M05","Undefined"})
Click to expand...
Actually, you will want either 243.9000000001 or 244 in place of 243.9 in the
formula above, depending upon the number of decimal places in your data.
 
You could nest ifs, but it would probably be more efficient (and
easier to debug) if you used something like a vlookup instead.
 
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
 
Back
Top