Please tell me some important MS Excel formulae. I will give u ten points if u give me more than five?

Question

but don't tell me formula to find the total .

Answer 1

average(x,y) will give the average of numbers
if (test, onTrue,onFalse) allows conditional processing
count(a,b,c) counts the numer of celss that have values
max (a,b,c) returns the largest value in a list
pmt(rate,nper,pv,fv,type) allows calculation of payments for a loan

To find more, open excel and click the fx option next to the bar where you type

Answer 2

in excel
right from where is says "A1" and under the spell check button in the top left corner there should be an "=".
click on it.
the word "average" should be written on the newly added menu.
there should be an arrow indicating a drop down menu, click it and there are about 10 different formulas and you can click "more functions" for a bigger list of formulas...

hope it helped

Answer 3

Go to mrexcel.com

It has some brilliant minds that solve problems (for free) in 10 minutes. I've used them for the last several years and they are excellent.

I've never seen a problem that one of their experts didn't have a solution

Answer 4

DATE(year,month,day)
YEAR(serial_number)
MONTH(serial_number)
count cells that contain numbers in a contiguous row or column
Select a cell below or to the right of the numbers that you want to count.
Click the arrow next to the AutoSum on the Standard toolbar, and then click Count and press ENTER.
go to
http://office.microsoft.com/

Answer 5

if()
this formula will give you possibility to make 8 conditional order test it and get more info from it help
second :
sum()
it will sum for you your data
average()
count()
max()
min()
sumif()
and()
or()
find()