What is the meaning of this formula?

`=B9/\$G\$3`
Nov 5, 2022 in Others 57 views

## 1 answer to this question.

It's an absolute reference: it means don't treat this as a relative reference if you copy/paste. If you copy that into the cell below to it, you'll get

`=B10/\$G\$3`

i.e. Excel has automatically updated the row in the formula for the new location of B9->10, but left G3 alone - i.e. it's a constant you've set once that you want to apply to all rows or cells in a table.

• 52,400 points

## In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS(\$H\$3:H3)<=\$I\$1,INDEX(Personnel! ...READ MORE

## Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE

## Excel Formula calculating the starting date of a given calendar week

The number of days to take into ...READ MORE

## Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE

## Repeated Multiplication formula for Excel

Fun little problem using some basic maths: =A1*3^ROW(A1) READ MORE