Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|