I'm trying to create an invoice for my painting business. I've received money and now finished the job so I would like to create an invoice that says 'this is how much it was', 'this is what you gave me to begin with' and now 'this is how much you owe me'.
Thanks!
Ted
Thank You! Can this kind of thing work in Pages as well?
I suggest letting Google assist you. I did a quick search and found some example here:
http://computers.tutsplus.com/tutorials/create-awesome-invoices-in-numbers--mac- 52791
once you know what you want post specific questions here.
That didn't help. I need to be able to subtract the money I've received from the total job to give a final balance due.
It would look like this:
Total Labor '$1,860.00'
Total Materials '$181.85'
Less Advace Rec'd '$1,105.00'
The fourth line would reflect the difference subtracting the third line from the total of the first two lines.
Thanks!
Ted
Pretty much just as you've described it, Ted:
B2: Entered data (1860)
B3: Entered data (181.85)
B4: Calculated: =SUM(B2:B3)
B5: Entered Data (1105)
B6: Calculated: =B4-B5
All cells are formatted as Number, with 2 decimal places.
If you want the $ signs, format the cells as Currency with 2 decimal places.
Regards,
Barry
You can copy a Numbers table, then paste it into a Pages document.
You can also create a table in Pages and use the same formulas as you would in Numbers. The biggest difference while setting up the table is that you don't get the column and row reference tabs that are available in Numbers.
Regards,
Barry
Thank you,
I've been typing up my estimates in Pages for years, but I didn't have Numbers till I upgraded my OS on the laptop a while back.
Never understood how to get those function things to do anything other than what was available in the insert menu.
Hi Ted,
You're welcome.
Numbers provides a description of every supported function in the Function Browser, which open whenever you click on a cell and type =
The browser allows searching for a specific function (or set of related functions), or seeing the list of functions in a specific category (by clicking the category name before entering anything in the search box.
Besides descriptions, the Browser provides at least one example of how you might use the function in a spreadsheet document.
Definitely worth exploring.
After reading "I've been using Pages for years," I did some exploring myself and found:
If you copy a Numbers 3 table with formulas then paste it into a Pages '09 document, he formulas are lost, and what is pasted in the last calculated result. inconvenient, but you can reinsert the formulas by copying them from the Formula Editor in Numbers, then double-clicking the same cell in the table in Pages, typing =, then pasting the copied formula into the Pages '09 table cell.
Pasting the same table into a Pages 5 document keeps the formulas intact.
I mention this because there are several Pages users who have stuck with Pages '09 rather than use the current version, which is missing several useful features included in Pages '09.
Regards,
Barry
Trying to create an invoice in Numbers
