ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you multiple, subtract and divide in the Excel program? (https://www.excelbanter.com/excel-worksheet-functions/150786-how-do-you-multiple-subtract-divide-excel-program.html)

Andrea

How do you multiple, subtract and divide in the Excel program?
 
I know how to add by clicking the sum button but theres no other button to
select any other mathmatical functions.

Toppers

How do you multiple, subtract and divide in the Excel program?
 
The basic formulae a

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

"Andrea" wrote:

I know how to add by clicking the sum button but theres no other button to
select any other mathmatical functions.


Duke Carey

How do you multiple, subtract and divide in the Excel program?
 
Excel's Help file has a wealth of examples. Search for

Examples of formulas


and then look for the Math section


"Andrea" wrote:

I know how to add by clicking the sum button but theres no other button to
select any other mathmatical functions.


SamIAm

How do you multiple, subtract and divide in the Excel program?
 
Evening. Click on the "FX" next to the formula bar...it will display a
wealth of potential mathematical options.
--
Sam


"Duke Carey" wrote:

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

Examples of formulas


and then look for the Math section


"Andrea" wrote:

I know how to add by clicking the sum button but theres no other button to
select any other mathmatical functions.



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com