Formula to Net and add tax

[Becky]

I have a spreadsheet with one column that I enter an amount paid, I would
like to net that number down 15% and then add 6.75% sales tax automatically
to the amount I entered.

Any suggestions?

Thank you,
Becky

[Bob Phillips]

Hi Becky,

Does net down 15% just mean reduce by 15%. If so then

=A1*85%*106.75%

perhaps

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Becky" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with one column that I enter an amount paid, I would
> like to net that number down 15% and then add 6.75% sales tax
automatically
> to the amount I entered.
>
> Any suggestions?
>
> Thank you,
> Becky
>

[Becky]

That was exactly what I meant! Thank you so much Mr Phillips for your help!

"Bob Phillips" wrote:

> Hi Becky,
>
> Does net down 15% just mean reduce by 15%. If so then
>
> =A1*85%*106.75%
>
> perhaps
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Becky" <[email protected]> wrote in message
> news:[email protected]...
> > I have a spreadsheet with one column that I enter an amount paid, I would
> > like to net that number down 15% and then add 6.75% sales tax
> automatically
> > to the amount I entered.
> >
> > Any suggestions?
> >
> > Thank you,
> > Becky
> >
>
>
>