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
---------------------------------------------------
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
(text/plain)