Results 1 to 11 of 11

formula for deriving taxable amount from total amount.

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2019
    Location
    india
    MS-Off Ver
    2010
    Posts
    13

    formula for deriving taxable amount from total amount.

    hi,

    can anyone help on this ?

    I have a invoice with GST rates of 5%, 12%, 18%, 28% columns.
    I want the sum of taxable value i.e. amount before GST.
    5% amount before GST in G26 cell,
    12% amount before GST in G27 cell,
    18% amount before GST in G28 cell,
    28% amount before GST in G29 cell,


    thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula to get the total qty and amount
    By ALLANT in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-20-2019, 02:52 AM
  2. 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
  3. Formula help determining amount $ per year amount from scale
    By saniafe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2015, 04:56 PM
  4. [SOLVED] The method of calculating the amount of taxable
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-19-2015, 09:27 AM
  5. Formula for amount owing subtract amount paid
    By Taperchart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2006, 12:55 PM
  6. Replies: 16
    Last Post: 05-04-2005, 04:26 PM
  7. 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