Forum Discussion
Mohammed Attarwala
May 21, 2018Copper Contributor
Help with cross multiplication in excel
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 ...
Matt Mickle
May 21, 2018Bronze Contributor
Maybe you can try using a formula like this (See attached file for reference):
Ex 1:
=A3*($B$2/$A$2) |
Ex 2:
=A4*3 |