Option #2

Name the value.  

Cell A1 = "Tax Rate"
Cell A2 = 6.5%

Give cell C2 a name of SalesTax

Cells C1-15 = sales subtotal
Enter into C2 "= C1 * SalesTax"
Enter into C3 "= C1 + C2"

Copy C2 and C3 down.

A little more work, but it documents what you are doing so you don't have to guess 6 months from now when you look at it again,  lol

Kevin

⁣Sent from BlueMail ​

On Jan 6, 2019, 8:30 PM, at 8:30 PM, Michael <bmike1@gmail.com> wrote:
>how do you pull a calc down but keep it static?
>
>--
>:-)~MIKE~(-:
>
>
>------------------------------------------------------------------------
>
>---------------------------------------------------
>PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>To subscribe, unsubscribe, or to change your mail settings:
>https://lists.phxlinux.org/mailman/listinfo/plug-discuss