+ Reply to Thread
Results 1 to 6 of 6

Formula to give An amount with 10% adding

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Formula to give An amount with 10% adding

    Hello every one,,

    Sorry..I could not explain you before..I want to add 10% amount of invoice as per excel attached..

    Pls help

    Thanks in advance

    ATTACHEMEN: Book3.xlsx
    Last edited by tariqnaz2005; 05-30-2012 at 04:52 PM. Reason: No Explanation Before

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: percentage formula adding 10%

    Hi Tariznaz,

    You can use below formula:-

    =ROUND(111.11-111.11*10%,0)

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292
    Void void void
    Last edited by tariqnaz2005; 05-30-2012 at 07:55 AM.

  4. #4
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Thumbs up Re: Formula to give An amount with 10% adding

    Sorry..I could not explain you before..I want to add 10% amount of invoice as per excel attached..

    Pls help

    Thanks in advance

    Book3.xlsx

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Formula to give An amount with 10% adding

    You need this in G4

    =F4/.9

  6. #6
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Re: Formula to give An amount with 10% adding

    Work perfectly...Thanks Cutter..u r great..
    Last edited by tariqnaz2005; 05-30-2012 at 04:51 PM.

+ 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