Help with cross multiplication in excel

Question

Hi friends,&nbsp;&nbsp;i need a little help with creating a cross multiplication formula in excel.&nbsp;&nbsp;For example:&nbsp;&nbsp;Glasses&nbsp; &nbsp; &nbsp;Kg2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 67&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&nbsp;This is the calculation i need to do.&nbsp;&nbsp;Also, i want to create a formula for when i just enter No. of glassses it will give me how much material i need to use.&nbsp;&nbsp;Please if someone can help me do it.&nbsp;&nbsp;Thank you

matt mickle · Answer

Maybe you can try using a formula like this (See attached file for reference):
&nbsp;
&nbsp;

&nbsp;
Ex 1:&nbsp;

=A3*($B$2/$A$2)

Ex 2:

=A4*3

christopherrath · Answer

=sumproduct()

ramiz_assaf · Answer

Mohammed Attarwala&nbsp;&nbsp;you can use VBA&nbsp;see the attached filethe function is called crossmult(a,b,c)a&nbsp; &nbsp;b&nbsp;c&nbsp; crossmult(a,b,c)

Forum Discussion

Help with cross multiplication in excel

3 Replies

Resources