Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.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. |
#3
Posted to microsoft.public.excel.worksheet.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. |
#4
Posted to microsoft.public.excel.worksheet.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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I program the cells in Excel to add, subtract, etc? | Excel Worksheet Functions | |||
subtract year and divide | Excel Worksheet Functions | |||
how do i subtract and divide | Excel Worksheet Functions | |||
subtract and divide | Excel Worksheet Functions | |||
how do I subtract years and then divide | Charts and Charting in Excel |