| geek_wendybob2 | February 8, 2010, 9:03 pm | #1 |
I'm TRYING to do a data sheet (micro, 2007 vista)
I have to enter all the invoices about 90 of them
The trouble I'm having is the gst and amount it keeps coming up #REF. . I know that I have done something wrong but I cant work it out
My lay out is--Date, Purchase place, Invoice, code, Qlt, Description, unit price (I), Extended (J) ---Gst (K), Balance (L)
I have entered unit price, and Extended price, , What I cant work out is HOW to add Gst 12. 5% then Balance ? ? ? ? I have never done this before, I have only used a template |
|
|
| geek_noah007 | February 8, 2010, 9:18 pm | #2 |
| Greetings! To add gst onto price is "=Z*1. 125" where Z is the gst exclusive price. Clear as mud? ? ? lol cheers |
| geek_wendybob2 | February 8, 2010, 9:19 pm | #3 |
| Office people ect Help! ! |
| geek_r.g.nixon | February 8, 2010, 9:21 pm | #4 |
| #2 is correct |
| geek_wendybob2 | February 8, 2010, 9:24 pm | #5 |
Thanks noah, ok got that, with the balance do I just press entre
soo Do I put the cell n# in eg. (K --
Sorry, but I just dont understand |
| geek_r.g.nixon | February 8, 2010, 9:29 pm | #6 |
| We don't know what the 'Balance' should be calculating? |
| geek_noah007 | February 8, 2010, 9:31 pm | #7 |
| Hi. What are you trying to balance? The formula I posted above results in the gst inclusive amount. To enter the formula, Click on the cell where you want the answer displayed. Type in the formula, ignoring the quotation marks, press enter. We will get there. Cheers! ! |
| geek_wendybob2 | February 8, 2010, 9:32 pm | #8 |
| From the Extended price (before GST) then Gst, then, Account balance |
| geek_noah007 | February 8, 2010, 9:32 pm | #9 |
| You obviously type faster then me... lol |
| geek_noah007 | February 8, 2010, 9:34 pm | #10 |
| Hi. It appears you want three fields. ie gst exclusive, gst amount, gst inclusive amount? ? ? |
| geek_r.g.nixon | February 8, 2010, 9:43 pm | #11 |
Give us a simple complete line as an example.
Like this:
Qlt, Desc, unit p (I), Extend (J), Gst (K), Balance (L)
2, TV, $500, $1000, $125, ? ? ? . |
| geek_wendybob2 | February 8, 2010, 9:48 pm | #12 |
Yes, sorry I didnt make that clear
I have been working on this for 4 days! ! ! ! I have looked in all the help coloums ect but I didnt get it
And I have another problem-----I have fiddled with the the data that much that I deleted some rows and add rows which I think is causing the #REF coming up in the amount coloum--- There is 90 rows of invoices
When I Try to copy it all to a new sheet (to make it look neater) It comes up with all the rows that I had deleted==== Im read to get paper and pen into action or through the comp into the pool! ! ! ! ! |
| geek_lostdude | February 8, 2010, 9:52 pm | #13 |
| Maybe you should invest in an accountant? ... LOL |
| geek_noah007 | February 8, 2010, 10:07 pm | #14 |
| Ok. Take a few deep breaths. Assuming the results you want are as in post 10. To obtain gst amount, "=a*. 125" where a is the gst exclusive amount. Your "Balance" is more likely a Total, which is the gst exclusive amount, plus gst. To obtain this Total, "=a+b" where a is the gst exclusive amount and b is the gst amount. Cheers. |
| geek_wendybob2 | February 8, 2010, 10:07 pm | #15 |
My lay out is--
Date(A)Purchase place(B)Invoice(C)code(D)Ql(E) blank cell(F)
08. 02. 09ITM12345xp1462. 00
Description(G)Description(H)unit price(I)Extended price(J)
dry 2x4Wood10. 0020. 00
Gst (K)Credit(L)Account Balance (M)
? ? ? |
| geek_r.g.nixon | February 8, 2010, 10:11 pm | #16 |
GST=J*. 125
Credit= we don't know what you mean.
Balance = ? balance of what account? Is this a running total down the page? |
|
|
| geek_wendybob2 | February 8, 2010, 10:20 pm | #17 |
Credit is what we returned
What Im trying to do is---copy all invoices, received also the credits (returns)
Im doing this for an excise for my self to try to understand how it all works |
| geek_wendybob2 | February 8, 2010, 10:21 pm | #18 |
| Running total down the page |
| geek_noah007 | February 8, 2010, 10:21 pm | #19 |
| Can u post a contact addy in this format eg: wendybob at xtra dot co dot nz. I will send you a sheet you can edit. Otherwise we may be here all night... Regards. |
| geek_wendybob2 | February 8, 2010, 10:30 pm | #20 |
lesleylance at xtra dot co dot nz thanks |
| geek_wendybob2 | February 8, 2010, 10:38 pm | #21 |
| The member deleted this message. |
| geek_noah007 | February 8, 2010, 10:39 pm | #22 |
| Done. Cheers! ! ! |
| geek_wendybob2 | February 8, 2010, 10:40 pm | #23 |
| Thanks |
| geek_drcspy | February 9, 2010, 4:00 am | #24 |
| rofl like pulling teeth without anaesthetic |
| geek_speedy_1 | February 9, 2010, 10:45 am | #25 |
| the #ref is because of the rows/cells you deleted, the cells reporting '#ref' are trying to calculate a result for you but the cells they refer to for info dont exist or are labels etc. double click in the cell saying #ref and the cells referring will highlight themselves with coloured borders, you can then see where you went wrong. |
| geek_sapper1 | February 9, 2010, 9:07 pm | #26 |
Wendybob2 - this site might help you if you are new to Excel. It is the best site I know of and is really simple to understand.
www.techonthenet.co/excel/formulas/index. php |
| geek_wendybob2 | February 9, 2010, 9:46 pm | #27 |
sapper1Thanks, I have had a quick look and it looks great, Im sooo muddled up in the formulas
Thanks |
| geek_timberman | February 9, 2010, 10:06 pm | #28 |
| Would you like me to email you a sheet on what I think you need as an example |
| geek_dunedin_ree | February 9, 2010, 10:09 pm | #29 |
| Buy a "Dummies" or "Idiots" guide or a teach yourself Excel book or take a free course at your local polytech etc ... if you want to learn, do it properly. |
| geek_wendybob2 | February 9, 2010, 10:10 pm | #30 |
Yes pleaselesleylance atxtra dotco donz
Let me know when you read this so I can delet
Thanks |
|
|
| Leave your comment: |
|
