+ Reply to Thread
Results 1 to 3 of 3

Calculate GST amount etc

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    Wauchope, Australia
    MS-Off Ver
    10
    Posts
    2

    Calculate GST amount etc

    Can someone tell me how to have the amount (in $ currency) in one cell divided by 11 and the quotient entered into another cell on the same row; then the quotient amount subtracted from the original amount and the result entered into a third cell in the same row. Would it be possible to do the calculation in one go? The results to two decimal places ie $120.56 Thankyou, dianaL

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Calculate GST amount etc

    Hi Diana, yes, you can do it in one go. If original amount is in A2, enter this formula in the "third cell":
    =$A2-$A2/11

    You'll need to format the cell (or column) containing the formula as "Currency" (Home ribbon).

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
    Last edited by leelnich; 05-23-2017 at 04:16 AM.

  3. #3
    Registered User
    Join Date
    05-23-2017
    Location
    Wauchope, Australia
    MS-Off Ver
    10
    Posts
    2

    Smile Re: Calculate GST amount etc

    To leelnich, thankyou very much for your most elegant algebraic solution to my question - it works either way as well. Cheers, dianaL

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to calculate Amount Paid and Amount Past Due
    By TinaAlldredge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2016, 09:19 AM
  2. [SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  3. Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  4. [SOLVED] Calculate dollar amount paid if between a to and from amount
    By oxicottin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2012, 08:01 PM
  5. Replies: 1
    Last Post: 03-03-2010, 05:26 AM
  6. How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM
  7. [SOLVED] How do I calculate Amount of Sales Tax from Total Amount?
    By MikeS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 04:06 PM

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