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: 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 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: 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 

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
