Formula to Net and add tax
 

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

Formula to Net and add tax
 

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" wrote in message
...
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

Formula to Net and add tax
 

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" wrote in message
...
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