Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 10-27-2016, 07:58 AM
xor xor is offline Excel Invoice Template Windows 10 Excel Invoice Template Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


See sheet Invoice_2
Attached Files
File Type: xlsx Invoice_4.xlsx (355.2 KB, 8 views)
Reply With Quote
  #17  
Old 10-27-2016, 08:19 AM
DMU62 DMU62 is offline Excel Invoice Template Mac OS X Excel Invoice Template Office for Mac 2011
Novice
Excel Invoice Template
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default

Great. Thanks!
Reply With Quote
  #18  
Old 11-02-2016, 09:46 AM
DMU62 DMU62 is offline Excel Invoice Template Mac OS X Excel Invoice Template Office for Mac 2011
Novice
Excel Invoice Template
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default

It's taken us some time to get around to actually using this sheet for a customer. We are using it today and seeing some issues.

First off we've noticed in lines 18, 19, 20, 25, 27, 28, 29 & 34 all totals are off by either .01 cent or .03 cents. Although the final total at the bottom is correct I would not print this out for a customer with some of the calculations being in correct. If I knew how these formula's work I would correct it myself.

Also, just a question....if my list grows too long for one sheet how do I go into additional sheets with one total at the end?

Thank you
Attached Files
File Type: xlsx Example.xlsx (355.6 KB, 9 views)
Reply With Quote
  #19  
Old 11-02-2016, 11:27 AM
xor xor is offline Excel Invoice Template Windows 10 Excel Invoice Template Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I have inserted round functions which should help. It hope it will work for you , but rounding can be tricky.

Can't you just insert new rows as needed? Select for example row 31 and insert required new rows. Then remember to copy down the formulas in E30 and F30 to the new inserted rows.
Attached Files
File Type: xlsx Invoice_5.xlsx (355.3 KB, 9 views)
Reply With Quote
  #20  
Old 11-02-2016, 12:17 PM
DMU62 DMU62 is offline Excel Invoice Template Mac OS X Excel Invoice Template Office for Mac 2011
Novice
Excel Invoice Template
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default

I looked over it and it does seem to be calculating correctly. I changed some of the numbers just to create new totals and they're correct.

Also, I understand what you're saying about inserting new rows and copying the formulas.
I will do that.

Thank you!
Reply With Quote
Reply

Tags
excel invoice

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Invoice Template Trying to create an invoice by cutting and pasting data from one excel speadsheet to another famres Excel Programming 8 03-21-2015 05:59 PM
Multiple Lines on an Invoice risnasmhd Mail Merge 2 09-29-2013 08:12 PM
Invoice Statement Shoshana3 Word 0 11-15-2010 03:02 PM
MSOA Express 2009: Export or Print custom modified Invoice Template derelyth Misc 0 10-19-2009 03:33 PM
Excel Invoice Template change currency $ to £ on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft