#16
|
|||
|
|||
See sheet Invoice_2 |
#17
|
|||
|
|||
Great. Thanks!
|
#18
|
|||
|
|||
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 |
#19
|
|||
|
|||
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. |
#20
|
|||
|
|||
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! |
Tags |
excel invoice |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
change currency $ to £ on excel invoice help | deanorx7 | Excel | 3 | 07-08-2008 04:40 AM |