Forum Discussion

Kerry_Smith's avatar
Kerry_Smith
Occasional Reader
Apr 23, 2026

I need Help with Cell Formatting to be able to copy

I have a number in a cell 

 

2022 
 NET
  
260 $               241.32

and I want to get the NET of that value by taking the 260 and multiplying it by another cell

Monthly Percentage 7%

and subtracting that number from the original 260. I then want to be able to copy the formula and paste it down the column yet making sure that the 7% Cell remains constant unlike the 260 cell. I forget how to do that. Help

Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Apr 23, 2026

    there are 2 good options:

    a) my preferenced is to NAME that 7% cell.  you can do that by clicking on the cell then clicking on the name of the cell to the left of the formula bar and typing a name:

     here is highlighted D10 and then highlighted the name to the left of the formula bar then typed a name for that cell: 

      alternatively you can go to Formulas -> Name Manager and add new name:

    either way now when you use that name in a formula it won't change when copied so

    =A4 - A4*Mpercent 

    b) simply prefix the row/column that shouldn't change using $ so

    = A4 - A4 * $D$4