JOIN NOW

Computer Applications

Explain Mixed Referencing

Spreadsheet

34 Likes

Answer

Mixed Referencing is a combination of relative and absolute referencing. In this reference, the data of one cell is kept absolute and other is made relative and finally they are operated together in a formula.

For example, let us consider that cell B5 has the formula =$B$3*B$4. When this formula is copied to C5 and D5, it will automatically get adjusted as below:

For C5, it will become =$B$3*C$4
For D5, it will become =$B$3*D$4

Answered By

20 Likes

Related Questions