How do you multiple, subtract and divide in the Excel program?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to add by clicking the sum button but theres no other button to
select any other mathmatical functions.
 
The basic formulae are:

Subtract:
=A1-B1
Multiply:
=A1*B1
Divide:
=A1/B1

There are other functions, such as SUMPRODUCT which do "complex" array
summations and multiplication.

Other functions such as AVERAGE,MAX,MIN can be found by clicking the arrow
by the "autosum" icon.

HTH
 
Excel's Help file has a wealth of examples. Search for

Examples of formulas


and then look for the Math section
 
Evening. Click on the "FX" next to the formula bar...it will display a
wealth of potential mathematical options.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Really simple question: subtract and divide 6
How to divide numbers in Excel? 0
Workday Formula to include date 0
subtract and divide 1
excel is calculating wrong again 3
Rounding up to a multiple of 12 1
index and match, then subtract, divide and add for my final answer 3
how do i subtract and divide 1

Back
Top