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