Jul 08 2020 07:38 AM
I would like to have a set price that each row will be able to mutiply by. Example
Set Cell (1F) $28.00
1 8 * 1F=
2 6.5 * 1F=
3 4 * 1F=
The Set Cell Can vary by job. Copying the first formula, it changes the next line to 2F and the next to 3F so on and so forth. Is there a way to make each line reference the 1F cell without typing each one individually?
Jul 08 2020 07:39 AM
Jul 08 2020 07:44 AM
Got that done. So I use the help there to try and figure this out? @Lewis-H
Jul 08 2020 10:16 AM
@Ronkartz_72, use absolute reference instead of relative reference - $F$1 instead of F1.