212708/excel-formula-meaning-of

What is the meaning of this formula?

=B9/$G$3

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.

A few explanations of why your formula ...READ MORE

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

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

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

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

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

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

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

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

Make sure that... There's an = sign before the formula There's ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.