EXCEL's decision to use
[Users questions | Browse:65 | Favorites]
Users questions: I want to N2 **- N30 all references in the number of B3, B3 changes, followed have changed how to do it
Experts answer: absolute cell reference: The calculation formula is stored not with the results of the cell varies. Relative reference: it refers to the formula of calculation results with the stored cell Change change. For example: In cell A3 has a formula = A1 + A2, this formula copied to cell B4, as is a relative reference, it becomes the formula = B2 + B3, which store the results into the cell by the A3 B4 , rows and columns are added one, then the formula of A1 and A2 lines And also add a column, into the B2 and B3. If it is in the A3 cell has a formula = $ A $ 1 + $ A $ 2, that is absolute references, then this formula copied to the B4 cells, because it is an absolute reference, it's formula is still = $ A $ 1 + $ A $ 2, will not change.
Experts answer: absolute cell reference: The calculation formula is stored not with the results of the cell varies. Relative reference: it refers to the formula of calculation results with the stored cell Change change. For example: In cell A3 has a formula = A1 + A2, this formula copied to cell B4, as is a relative reference, it becomes the formula = B2 + B3, which store the results into the cell by the A3 B4 , rows and columns are added one, then the formula of A1 and A2 lines And also add a column, into the B2 and B3. If it is in the A3 cell has a formula = $ A $ 1 + $ A $ 2, that is absolute references, then this formula copied to the B4 cells, because it is an absolute reference, it's formula is still = $ A $ 1 + $ A $ 2, will not change.
- Cell in Excel for graphics.
- domn down the word document, how to remove shading
- Download the Google input Thunder
- PPT pie method to do? Can quickly learn
- How to restore the default browser status ie
- WORD2003 program is broken
- the difference between word and wps?
- Ask CSS problems
- Hide Add Remove Programs
- Computer system and antivirus software
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.