View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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