Help me make a percentage file

Discuss the spreadsheet application

Help me make a percentage file

Postby abdoadawy65 » Thu Aug 06, 2020 5:25 pm

Help me make a percentage file
Who creates the file
I want to write an amount of money
It gives me a percentage and divides the result by the number of months
I sell in installments
Example
A commodity for $ 10,000
18 months rate 70%
The rate for 12 months 46%
24months rate 93%
6months rate 25%
36 months rate 138%
Last edited by MrProgrammer on Thu Aug 06, 2020 6:01 pm, edited 1 time in total.
Reason: Removed huge font
OpenOffice 3.1 on Windows 10
abdoadawy65
 
Posts: 5
Joined: Thu Aug 06, 2020 5:14 pm

Re: Help me make a percentage file

Postby RusselB » Thu Aug 06, 2020 10:44 pm

Welcome to the Forums.
Are the percentages given fixed?
Are they monthly, annual or term percentages?
Is there a reason your months are not in sequential order?
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6308
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Help me make a percentage file

Postby abdoadawy65 » Fri Aug 07, 2020 4:53 pm

Welcome to the Forums.
Are the percentages given fixed?
yes
Are they monthly, annual or term percentages?
yes
Is there a reason your months are not in sequential order?
The reason is the profit system is fixed at this rate

you can help me
Is there a reason your months are not in sequential order?
OpenOffice 3.1 on Windows 10
abdoadawy65
 
Posts: 5
Joined: Thu Aug 06, 2020 5:14 pm

Re: Help me make a percentage file

Postby jrkrideau » Fri Aug 07, 2020 7:07 pm

Hi abdoadawy65
It is not really clear what you want

Look at the attached file and see it is close to what you want.

There are better ways to do this but if it is close to what you want we may be able to help.
Attachments
abd.ods
(8.97 KiB) Downloaded 49 times
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3806
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Help me make a percentage file

Postby RusselB » Fri Aug 07, 2020 7:57 pm

abdoadawy65 wrote:Welcome to the Forums.
Are they monthly, annual or term percentages?
yes

OK, so which are they? The proper calculation of a percentage over a period of time depends on the time period that the given percentage is for.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6308
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Help me make a percentage file

Postby abdoadawy65 » Fri Aug 07, 2020 9:31 pm

jrkrideau wrote:Hi abdoadawy65
It is not really clear what you want

Look at the attached file and see it is close to what you want.

There are better ways to do this but if it is close to what you want we may be able to help.



very thanks
thank you so much
Please see the example in the attachment image and apply it
thank you so much
Attachments
1111.jpg
OpenOffice 3.1 on Windows 10
abdoadawy65
 
Posts: 5
Joined: Thu Aug 06, 2020 5:14 pm

Re: Help me make a percentage file

Postby jrkrideau » Sat Aug 08, 2020 5:28 pm

I am sorry but I do not understand what you are doing.

Do you want a monthly payment for each of the repayment times?
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3806
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Help me make a percentage file

Postby abdoadawy65 » Sat Aug 08, 2020 6:03 pm

what is your account facebook or whatasapp
OpenOffice 3.1 on Windows 10
abdoadawy65
 
Posts: 5
Joined: Thu Aug 06, 2020 5:14 pm

Re: Help me make a percentage file

Postby Hagar Delest » Sat Aug 08, 2020 6:49 pm

Sorry but this is not a customer service.
The point of the forum is to have open discussion so that other users benefit from the advice provided here.
Can't you describe what you're trying to achieve? It's still very confusing.
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 7.1 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29425
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Help me make a percentage file

Postby abdoadawy65 » Sat Aug 08, 2020 7:09 pm

I will explain what I want with an example
I sell in installments
The price for the product is 1000
Profit rate 18 months 70%
1000 * 70/100
= 700
+ The price for the product is 1000
/ 18 months
OpenOffice 3.1 on Windows 10
abdoadawy65
 
Posts: 5
Joined: Thu Aug 06, 2020 5:14 pm

Re: Help me make a percentage file

Postby Hagar Delest » Sat Aug 08, 2020 9:18 pm

Here is what I understand:
abd.ods
(8.82 KiB) Downloaded 42 times
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 7.1 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29425
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: mike.stirton, robleyd and 21 guests