<html><head></head><body><div dir="auto">Option #2<br><br></div>
<div dir="auto">Name the value. <br><br></div>
<div dir="auto">Cell A1 = "Tax Rate"<br></div>
<div dir="auto">Cell A2 = 6.5%<br><br></div>
<div dir="auto">Give cell C2 a name of SalesTax<br><br></div>
<div dir="auto">Cells C1-15 = sales subtotal<br></div>
<div dir="auto">Enter into C2 "= C1 * SalesTax"<br></div>
<div dir="auto">Enter into C3 "= C1 + C2"<br><br></div>
<div dir="auto">Copy C2 and C3 down.<br><br></div>
<div dir="auto">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<br><br></div>
<div dir="auto">Kevin<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Sent from <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=14063"><!-- tmjah_g_1299s -->BlueMail<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On Jan 6, 2019, at 8:30 PM, Michael <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">how do you pull a calc down but keep it static?<br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><span style="font-size:12.8000001907349px">:-)~MIKE~(-:</span><br></div></div></div></div></div></div>
<pre class="blue"><hr><br>PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org<br>To subscribe, unsubscribe, or to change your mail settings:<br><a href="https://lists.phxlinux.org/mailman/listinfo/plug-discuss">https://lists.phxlinux.org/mailman/listinfo/plug-discuss</a></pre></blockquote></div></body></html>