NZGeek


Exle help Please

geek_wendybob2February 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_noah007February 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_wendybob2February 8, 2010, 9:19 pm#3
Office people ect Help! !
geek_r.g.nixonFebruary 8, 2010, 9:21 pm#4
#2 is correct
geek_wendybob2February 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.nixonFebruary 8, 2010, 9:29 pm#6
We don't know what the 'Balance' should be calculating?
geek_noah007February 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_wendybob2February 8, 2010, 9:32 pm#8
From the Extended price (before GST) then Gst, then, Account balance
geek_noah007February 8, 2010, 9:32 pm#9
You obviously type faster then me... lol
geek_noah007February 8, 2010, 9:34 pm#10
Hi. It appears you want three fields. ie gst exclusive, gst amount, gst inclusive amount? ? ?
geek_r.g.nixonFebruary 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_wendybob2February 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_lostdudeFebruary 8, 2010, 9:52 pm#13
Maybe you should invest in an accountant? ... LOL
geek_noah007February 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_wendybob2February 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.nixonFebruary 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_wendybob2February 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_wendybob2February 8, 2010, 10:21 pm#18
Running total down the page
geek_noah007February 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_wendybob2February 8, 2010, 10:30 pm#20

lesleylance at xtra dot co dot nz thanks
geek_wendybob2February 8, 2010, 10:38 pm#21
The member deleted this message.
geek_noah007February 8, 2010, 10:39 pm#22
Done. Cheers! ! !
geek_wendybob2February 8, 2010, 10:40 pm#23
Thanks
geek_drcspyFebruary 9, 2010, 4:00 am#24
rofl like pulling teeth without anaesthetic
geek_speedy_1February 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_sapper1February 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_wendybob2February 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_timbermanFebruary 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_reeFebruary 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_wendybob2February 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:
Comment *
Name
 

NZGeek Message Board > Exle help Please


Other topics:RepliesLast post
computer helpJanuary 1, 1970, 12:00 pm
Free program like word..January 1, 1970, 12:00 pm
download speedJanuary 1, 1970, 12:00 pm
SKYPE problemJanuary 1, 1970, 12:00 pm
NZGeek | Message Board | Blog | Tag Cloud
© 2010 http://nzgeek.org