ExcelBanter - how do I take a sub total field and calculate sales tax to it

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do I take a sub total field and calculate sales tax to it (https://www.excelbanter.com/new-users-excel/144236-how-do-i-take-sub-total-field-calculate-sales-tax.html)

Michael Beck

how do I take a sub total field and calculate sales tax to it

trying to take a total cell. and add sales tax to it.

Roger Govier

how do I take a sub total field and calculate sales tax to it

Hi Michael

With Total in A1` and Sales tax in B1 e.g. 7%
=A1*(1+B1)

--
Regards

Roger Govier

"Michael Beck" <Michael wrote in message
...
trying to take a total cell. and add sales tax to it.

All times are GMT +1. The time now is 07:06 PM.