| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
richhill
OOo Advocate
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. |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
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 wich is A1+30% = 3,26
then add 1,50 in C1 wich will be wich will give 4,76
finally times 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 |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
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 |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| 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. |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
|
|
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
|
Powered by phpBB © 2001, 2005 phpBB Group
|
