[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
aptsolutions
Newbie

Joined: 27 Aug 2004
Posts: 2
Location: Maryborough Victoria australia 3465

 Posted: Fri Aug 27, 2004 9:30 pm    Post subject: trying to insert calculation Relatively new to Open Office ( after using Lotus for years) and loving it. Am into embroidery am trying to make up a price list but just can not get the formula right. It goes like this : Base price = cost price + % handling + embroider cost For example Base price = \$2.51 + 30% + \$1.50 which should be \$4.76 But what I end up with on the streadsheet is \$4.31 From here I then adjust for quantities Sell price = Base Price + 50% Where \$4.76 + 50% should be \$7.14 I actually end up with \$5.26 ( which is just \$4.76+.5) So can anyone help?_________________From the land down under
richhill

Joined: 16 Jun 2004
Posts: 418
Location: Mesa, AZ

 Posted: Fri Aug 27, 2004 11:05 pm    Post subject: Without seeing your forumla you are using - I don't know what you are doing wrong... I put A1 = \$2.51 and B1 = (a1*1.3)+1.5 and it calculates to \$4.76 Like wise with A1 = \$4.76 , with B1 =A1*1.5, we get \$7.14 Rather than add 30% and 50%, multiply by 1.3 and 1.5 respectively.
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

Posted: Sat Aug 28, 2004 4:58 am    Post subject: re: trying to insert calculation

However,

if you wanna stick with percentages, try this:

A1 = 2,51 then b1 will be
 Code: =(A1)+(A1*0,3)
wich is A1+30% = 3,26

then add 1,50 in C1 wich will be
 Code: B1+1,5
wich will give 4,76

finally times 50%
 Code: C1*0,50
wich wil give you 7,14

With this coding, as with the one from Richill, you can see were you're figures come from and you're are able to hide the cells or columns you don't wanna see

It is however possible to put all in one like
 Code: =((A1+(A1*0,3)+1,5)*0,5)+A1+(A1*0,3)+1,5

wich will give you also 7,14

Good luck, and have fun

DiGro
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

 Posted: Sat Aug 28, 2004 5:04 am    Post subject: re: trying to insert calculation Regarding the point where you went wrong I think you were adding 0,3 to 2,51 +1,50 which gave you 4,31 instead of multiplying 2,51+1,50 with 0,3 wich should have given you 4,76 Been there too Greetings, DiGro
David
Super User

Joined: 24 Oct 2003
Posts: 5668

Posted: Sat Aug 28, 2004 8:08 am    Post subject: Re: trying to insert calculation

 aptsolutions wrote: Relatively new to Open Office ( after using Lotus for years) and loving it. Am into embroidery am trying to make up a price list but just can not get the formula right. It goes like this : Base price = cost price + % handling + embroider cost For example Base price = \$2.51 + 30% + \$1.50 which should be \$4.76 But what I end up with on the streadsheet is \$4.31 From here I then adjust for quantities Sell price = Base Price + 50% Where \$4.76 + 50% should be \$7.14 I actually end up with \$5.26 ( which is just \$4.76+.5) So can anyone help?

You don't show the formula you used [just the method.]

If you had an amount in A1, then in B1 you could put this:

=1.3*A1+1.5

For the selling price, say in C1, you'd put this:

=1.5*B1

Format for dollar amounts.

David.
aptsolutions
Newbie

Joined: 27 Aug 2004
Posts: 2
Location: Maryborough Victoria australia 3465

 Posted: Sat Aug 28, 2004 9:45 pm    Post subject: trying to insert calculation Thanks Richhill, DiGro, and David for your replies - I can see where I have stuffed up on the codes. With such a wealth of information I know that I'll get it right now. Just need a moment to get over the shock of receiving such prompt and helpful assistance so fast !!!! I am hoping, in time, to be able to offer my assistance to some other newbie just as I have been helped. I think that there is not a day that there goes past when I learn more about the capabilities of OpenOffice. Once again - THANKS_________________From the land down under
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum