Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Calculate Net Pay After Tax

  1. #1
    Join Date
    18th February 2008
    Posts
    4

    Calculate Net Pay After Tax

    Hi. building a spreadsheet and have gotten stumped. I have the total price in cell f6. In cell C6 I need price with no taxes. D6 should be the pst of 8% and E6 should be the gst of 5%. I realize this is working backwards and that is why it is stumping me so badly. Your help would be so great appreciated, been trying for hours! Thank you so much!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th September 2005
    Location
    Hampshire, UK
    Posts
    1,278

    Re: Formula To Subtract Tax From Total

    Hi

    Assuming that the tax operates as follows:

    Net price AUD$100
    PSt @ 8% = AUD$8
    GST @ 5% = AUD$5

    Then C6

    =F6*(100/(100+8+5))

    D6:

    =F6*8/(100+8+5)

    E6:

    =F6*5/(100+8+5)

    Richard

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: Formula To Subtract Tax From Total

    You may want to round two of the formulas and plug the third calculation.

    D6
    =ROUND(F6*8/(100+8+5),2)

    E6
    =ROUND(F6*5/(100+8+5),2)

    C6
    =F6-D6-E6
    Bill
    Tip: To avoid chasing code always use Option Explicit.

  4. #4
    Join Date
    18th February 2008
    Posts
    4

    Re: Calculate Net Pay After Tax

    Thank you so much! Worked perfectly!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Calculate Sum By Week
    By wydra in forum EXCEL HELP
    Replies: 7
    Last Post: March 2nd, 2012, 17:19
  2. XL98: Using Calculate Method May Not Calculate Certain Formulas
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 15:15
  3. Using Calculate Method May Not Calculate Certain Formulas
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 15:15
  4. Cells Will Not Calculate
    By ZoeA in forum EXCEL HELP
    Replies: 2
    Last Post: February 26th, 2007, 19:12
  5. Calculate wb every nth second
    By thoemmes in forum EXCEL HELP
    Replies: 1
    Last Post: July 23rd, 2005, 01:00

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
  •  
porno