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. |
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. |
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. |
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