Q. How do I setup a formula in Excel that has both multiplication and division?
The first thing you want to do after typing the = key is to setup Parentheses ( ) for what you want to multiply. Numbers within the parentheses will be calculated first. A slash is used to indicate division.
Ex: =(6*3)/6 will be 6 multiplied by 3 and then divided by 6 which would equal 3