multiple criteria calculation

[The Big Bear]

HI all

I am trying to write a summary of my company welding procedures but I hit a snag.

The criteria is as follows:

3/4" to less than 1 1/2" and 2t when t< 3/4"

3/4" to less than 1 1/2" and 2T when t> 3/4"

What I need to find is a calculation that would give the range beginning with 3/4" up to 1 1/2".

I tried the following

Case(

thickness =.750 or thickness <= 1.5 and weld < .750,2*thickness;

thickness = .750 or thickness <= 1.5 and weld > .750, 2* metalthickness)

little t is the weld metal deposit thickness

Larger T is the metal thickness.

At first glance that seems to work but further investigation prove that it did not wotk.

The problem is the equal to less than symbol.

Thanks for all your help

Lionel

The equal to and the less than symbol

[sbg2]

Your calc is in essence asking for anything less than or equal to a thickness of 1.5 - try the following:

 Case(

thickness >= .750 AND thickness <= 1.5 and weld < .750,2*thickness;

thickness >= .750 AND thickness <= 1.5 and weld > .750, 2* metalthickness

Also, you realize a weld at .750 would not figure into this calculation? You are asking for <.750 and then >.750, by doing that you miss a value of .750.

Edited January 29, 2008 by Guest

[The Big Bear]

thanks

that exactly what I was trying to do