What are the rules to write a formula in Excel?

Question

anonymous · Answer

Check out this cheat sheet: http://chandoo.org/img/e2010/formula-cheat-sheet.pdf - Starting with an equal sign in the destination cell, you then write out the formula you wish to use - You can relatively reference the value of a cell by using it's name (D14, A1, F5, etc..) - You can directly reference the value of a cell by using it's name with dollar signs placed around it's column letter ($D$14, $A$1, $F$5, etc..) - You can reference ranges of cells by using the ":" delimiter (A1:A15 selects cells A1 through A15) - Various functions are at your fingertips to quickly perform common arithmetic operations (like STDEV(range) for standard deviation of the range, AVERAGE(range) for finding the mean of the range, SUM(range) for finding the sum of the range, and SQRT(value) for finding the square root of the value) - Arithmetic operators (+, -, *, /, and ^) follow the order of operations (so =3+9^2/2-1*2 resolves to 41.5)

alishba · Answer

thank you so much

anonymous · Answer

No problem!

dean.shyy · Answer

There is a rule for every formula you want to write. What type of formula to you want to write?