OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

trying to insert calculation

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
aptsolutions
Newbie
Newbie


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

PostPosted: Fri Aug 27, 2004 9:30 pm    Post subject: trying to insert calculation Reply with quote

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
View user's profile Send private message
richhill
OOo Advocate
OOo Advocate


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

PostPosted: Fri Aug 27, 2004 11:05 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
DiGro
Super User
Super User


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

PostPosted: Sat Aug 28, 2004 4:58 am    Post subject: re: trying to insert calculation Reply with quote

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, Laughing and have fun

DiGro
Back to top
View user's profile Send private message
DiGro
Super User
Super User


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

PostPosted: Sat Aug 28, 2004 5:04 am    Post subject: re: trying to insert calculation Reply with quote

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 Crying or Very sad Crying or Very sad

Greetings,
DiGro
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sat Aug 28, 2004 8:08 am    Post subject: Re: trying to insert calculation Reply with quote

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
View user's profile Send private message
aptsolutions
Newbie
Newbie


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

PostPosted: Sat Aug 28, 2004 9:45 pm    Post subject: trying to insert calculation Reply with quote

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 !!!! Shocked Smile
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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

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