Help with cross multiplication in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-195657%22%20slang%3D%22en-US%22%3EHelp%20with%20cross%20multiplication%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195657%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20friends%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20a%20little%20help%20with%20creating%20a%20cross%20multiplication%20formula%20in%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlasses%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BKg%3C%2FP%3E%3CP%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206%3C%2FP%3E%3CP%3E7%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20calculation%20i%20need%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20i%20want%20to%20create%20a%20formula%20for%20when%20i%20just%20enter%20No.%20of%20glassses%20it%20will%20give%20me%20how%20much%20material%20i%20need%20to%20use.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20if%20someone%20can%20help%20me%20do%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-195657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-195754%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20cross%20multiplication%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195754%22%20slang%3D%22en-US%22%3E%3CP%3EMaybe%20you%20can%20try%20using%20a%20formula%20like%20this%20(See%20attached%20file%20for%20reference)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CrossMultiplication.png%22%20style%3D%22width%3A%20420px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34525i0DB843E3787ED55D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22CrossMultiplication.png%22%20alt%3D%22CrossMultiplication.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEx%201%3A%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20width%3D%22255%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22255%22%3E%3DA3*(%24B%242%2F%24A%242)%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3EEx%202%3A%3C%2FP%3E%0A%3CTABLE%20width%3D%22255%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22255%22%3E%3DA4*3%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1310363%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20cross%20multiplication%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1310363%22%20slang%3D%22en-US%22%3E%3Dsumproduct()%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1654296%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20cross%20multiplication%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1654296%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F148786%22%20target%3D%22_blank%22%3E%40Mohammed%20Attarwala%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20use%20VBA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20the%20attached%20file%3C%2FP%3E%3CP%3Ethe%20function%20is%20called%20crossmult(a%2Cb%2Cc)%3C%2FP%3E%3CP%3Ea%26nbsp%3B%20%26nbsp%3Bb%26nbsp%3B%3C%2FP%3E%3CP%3Ec%26nbsp%3B%20crossmult(a%2Cb%2Cc)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi friends, 

 

i need a little help with creating a cross multiplication formula in excel. 

 

For example: 

 

Glasses     Kg

2                6

7                ?

 

This is the calculation i need to do. 

 

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. 

 

Please if someone can help me do it. 

 

Thank you

3 Replies

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

 

 

CrossMultiplication.png

 

Ex 1: 

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

Ex 2:

=A4*3
=sumproduct()

@Mohammed Attarwala 

 

you can use VBA

 

see the attached file

the function is called crossmult(a,b,c)

a   b 

c  crossmult(a,b,c)