Count as Percentage

[arif]

I have a sheet where i want to count tax on money shown in one column
so if i want to put a formula that if "tax is 5% then multiply a with 5%, if its 6% then multiply with 6% or so on with other tax figure" how can i do that using if formula

plz

 

[Splash]

Hi,
Not sure why you feel the need for an 'if' statement. Just use the following formula in whichever cell you want the result.
=C3*D3
or, if you want the total with tax added
=C3*(1+D3)
then copy the formula down for each row.
Hope that helps

 

[Khalid NGO]

Hi Arif,
I didn't understand your requirement...

You have values in Column C
Percentage in D

All you need is just =D3*C3

 

[Mike H..]

I have a sheet where i want to count tax on money shown in one column
so if i want to put a formula that if "tax is 5% then multiply a with 5%, if its 6% then multiply with 6% or so on with other tax figure" how can i do that using if formula

plz

Hi,

Does this do what you want?