af Carol Robertson 14 år siden
321
Mere som dette
Relative cell referencing allows cells to change when a formula is replicated through a range of cells
Absolute cell referencing fixes a cell so that it doesn't change when a formula is replicated through a range of cells
Cell attributes can be changed/formatted:
bold
italics
colour
number of decimal places
percentage
currency
etc
Finds the smallest value in a range of cells
finds the biggest value over a range of cells
finds the average over a range of cells
adds a range of cells
=SUM (A5:A10)
Use this to find out if a condition exists
IF ( condition exists, then enter this , otherwise this )
Example
=IF(B3>100 , £100 , 0 )
or
=IF(D9 > 50 , "Discount", " ")
Examples are :
=A5+B5
=C2*B4