Forum Discussion

Copper Contributor

Jan 31, 2018

Percentage

I am working on a bills spreadsheet and need to add a tax payment to be 15% of my monthly. Does anyone know a formula for this? For example if I have my income listed in B5 and this month it...

excel

Formulas and Functions

Damien_Rosario

Silver Contributor

Jan 31, 2018

Hi Amanda

If you are just looking for a formula to show $15 (tax) from the $100 (monthly income), try this formula in cell B27 (or where ever else you want it):

= B5*0.15

Hope that helps?

Cheers

Damien