I have Microsoft Excel 2003. Can anyone tell the following formulas for Excel?

Question

Multiplication
Division
Subtraction
Percentages

I would also like to now how to use the filter function.

I have already tried on line training packs and books but none of them are compatible with Excel 2003.

Answer 1

=SUM(A4*A8) MULTIPLICATION
=SUM(A4+A8) ADDITION
=SUM(A4-A8) SUBTRACTION
=SUM(A4/A8) DIVISION

Understanding filters, you can get info in the help screen or try
this link

Answer 2

To make anything a formula you need to start the cell with "=" So for multiplication typing "=4*3" will give the result 12. The symbol for division is "/" and for subtraction is "-".

Alternatively, =product(x, y, z...) can do multiplication and =quotient(x,y) can do division

If you want to show something as a percentage you can just choose that style as the cell format.

Filter is best explained in the Excel built-in help. Is this enough?

Answer 3

Multiplication: = 2*2
Division: = 4/2
Subtraction: =3-1
Percentages: it's not a function, it's a format. Say, you have a cell that says 0.37. If you click the percentage button on the formatting toolbar, it will display as 37%.

Filter function... Select the data you want to filter. Then click on Data | Filter | Auto Filter. Then, use the drop-down menus that appear on top of your data area to filter the data.

Answer 4

multiplication is th e* sign
division is the / sign
Subtraction - sign

see the number key pad to right of your keyboard

formulas look like: =

=A1-A2

or

=B16/A54


Filter function

create a verical list in column A

a
d
a
s
e
tr
f
a
f


Now click on teh top cell and click tools fileter auto filter

you then click on teh drop down and select what you want

You can choose customise to filter better.

Use the help on the menu
or press F1

Answer 5

Not sure if it is in 2003 as I have 2010 but in Formulas, there is a Date/Time field. Also, have you tried formatting a cell to accept a date Field?

Answer 6

Google has free spreadsheets that with just the click of a button do all that. I think it will show you the formula there.

Answer 7

just click the "Fx" button that is next to the bar where you input information for each cell. from there you will be able to choose which function you would like and just click on the cells you want it to perform that function on.

Answer 8

click on the Fx on the 3rd or 4th line. click on it and it will give u millions of formalues. u can look fot what ur looking for under math. good luck