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
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
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]
Void void void
Last edited by tariqnaz2005; 05-30-2012 at 07:55 AM.
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
You need this in G4
=F4/.9
Work perfectly...Thanks Cutter..u r great..
Last edited by tariqnaz2005; 05-30-2012 at 04:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks