Forum Discussion

Amanda Butt's avatar
Amanda Butt
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 is $100.  I want B27 (where I have my monthly taxes) to show $15 which is 15% of B5.  

excel
Formulas and Functions

1 Reply

  • Damien_Rosario's avatar
    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

Resources