+ Reply to Thread
Results 1 to 3 of 3

Percentage Formula for Tax Split?

  1. #1
    Registered User
    Join Date
    04-28-2007
    Posts
    4

    Percentage Formula for Tax Split?

    Hi, I just cannot for the life of me get my head round this to make a formula...

    I have a small business, the profit of my business i.e £5000.00 is split 75/25% between me and my wife as she does more than me.

    What I simply need is a formula that divides the split into a total something like this:

    £5000.00 profit split by 75% and 25% tax charged at 22% for 75% split and 40% for 22% split and a total of what we would jointly pay, or even seperate would be cool thinking bout it?

    Help much appreciated!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Quote Originally Posted by minker
    Hi, I just cannot for the life of me get my head round this to make a formula...

    I have a small business, the profit of my business i.e £5000.00 is split 75/25% between me and my wife as she does more than me.

    What I simply need is a formula that divides the split into a total something like this:

    £5000.00 profit split by 75% and 25% tax charged at 22% for 75% split and 40% for 22% split and a total of what we would jointly pay, or even seperate would be cool thinking bout it?

    Help much appreciated!
    a1 has the profit

    =a1*.75*.22 is 22% 0f 75%
    so
    =a1-(a1*.75*.22 ) wll give what is remaining after taxes at 75% share

  3. #3
    Registered User
    Join Date
    04-28-2007
    Posts
    4

    hi

    Dave, many thanks it worked great! it looks so simple but took me hours to try to achieve it!

    Thanks Again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1