software

I have one question. I think it will be simple for You.

For exaple I have array:

Length Width Thickness Mass
40 40 2,0 1
40 40 3,0 2
40 40 3,5 3
40 60 2,0 5
40 80 3,0 8

I would like to find a value of mass when I know value of Length, Width and
Thickness. How can I do it? Do You have any suggestions?BSTR

Tom
Hi Tomek S,

Mass = Length*Width*Thickness*Density, so you need to know the Density.

Ken JohnsonI don't want to calculate mass!! I wanto to find in the array value of mass
when I know values of Width, Length and thickness. I want to seek array to
find this value!!

Best RedardsTom
Sorry about that!
If required length is in A1, required Width in B1, required Thickness
is in C1 then...

=SUMPRODUCT((A2:A6=A1)*(B2:B6=B1)*(C2:C6=C1)*D26 ) will return the
Mass

Just change the array addresses to include all of you data.

Ken JohnsonHi Tom,
Maybe you meant Best Retards, which is what I felt like after my first
reply:-)
Ken Johnson
Uzytkownik quot;Ken Johnsonquot; gt; napisal w wiadomosci oups.com...
gt; Hi Tom,
gt; Maybe you meant Best Retards, which is what I felt like after my first
gt; reply:-)
gt; Ken Johnson
gt;

No! I meant Best Regards . My mistake but I admit Your post wasn't funny
( at first moment).

Best regard

TomHi,

Though sumproduct is a better formula to use, here is an array formula
alternative (Ctrl Shift Enter)

=sum(if((rangeA=length)*(rangeB=width)*(rangeB=thi ckness),rangeC))

Regards,

Ashish Mathur

quot;Tomek Squot; wrote:

gt; I have one question. I think it will be simple for You.
gt;
gt; For exaple I have array:
gt;
gt; Length Width Thickness Mass
gt; 40 40 2,0 1
gt; 40 40 3,0 2
gt; 40 40 3,5 3
gt; 40 60 2,0 5
gt; 40 80 3,0 8
gt;
gt; I would like to find a value of mass when I know value of Length, Width and
gt; Thickness. How can I do it? Do You have any suggestions?
gt;
gt;
gt; BSTR
gt;
gt; Tom
gt;
gt;
gt;