oldeirish
New Member
- Joined
- Nov 24, 2014
- Messages
- 40
How to calculate 7% of tax from 3 different columns? Can I input all my data then convert to a table?
<tbody>
</tbody>
This is the first I tried
=SUM([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*7%)
This is the 2nd one I tried
=SUMPRODUCT([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*0.07)
Thank you so very much!! J
New Subtotal | Credit | Over Due Fee | Column1 | HST 7% |
$ 365.00 | $ 5.00 | $ 10.00 | 37070% | |
$ 500.00 | $ 70.00 | $ 5.00 | 57035% |
This is the first I tried
=SUM([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*7%)
This is the 2nd one I tried
=SUMPRODUCT([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*0.07)
Thank you so very much!! J