Count money with tax

**anmol786** · 10-29-2014, 09:24 AM

See my worksheet and give me if formula

**Kamboj** · 10-29-2014, 09:31 AM

your formula is correct for first:

=IF(D3=5%,C3*0.05,IF(D3=6%,C3*0.06,IF(D3=7%,C3*0.07)))

**Olly** · 10-29-2014, 09:34 AM

In D27, enter:

Formula:

Please Login or Register  to view this content.

Copy down.

**anmol786** · 10-29-2014, 10:36 AM

What if i want to show only tax totally like 7% or like wise
what formula should be used

**Olly** · 10-29-2014, 10:45 AM

Tax amount only:

Formula:

Please Login or Register  to view this content.

Re: Count money with tax