Think this is what your after
$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3
"- Bobb -" wrote:
> Making a spreadsheet and trying to figure how to easily populate the
> formulas
> Acroos the top have columns for 10000, 20000, 30000, etc
> and down the rows have various percentages
> Each cell is merely the top column value times the percentage.
> I thought it simple until I tried to use autofill and BOTH variables
> increase - I want the column input toi stay the same.
>
> see attached for typical application that I'm trying to do
|
Similar Threads
