Spreadsheet for accounts (splitting various %)
- or -
Post a project like this2757
£7(approx. $9)
- Posted:
- Proposals: 5
- Remote
- #1291691
- Completed
Description
Experience Level: Entry
I need a spreadsheet to log earnings and split it into 4 separate amounts.
For example i input £100 and it splits it into 4 amounts, 1 column of %50 of the figure, 30%, 6% etc. It's for my accounts so i know how much to put into different bank accounts.
I want it to display a number, not percentage. it's just the formula that uses a percentage. For ease, set all columns to divide the to 25% each for now. As long as it's easily editable.
Also - I want it to display the amount and yearly total amount for EACH column.
I want columns to put the date, what the job was, the employer and then the amount. Once i put in the amount it'll split it up into how much i should put into various accounts.
Landscape mode too and compatible with both excel and google sheets.
Please make it look clean, i hate a messy spreadsheet as I'm sure you do too. No preferences over font or colour scheme, i can sort that. I imagine if excel if your thing, this is pretty simple.
ASAP please. Thanks.
For example i input £100 and it splits it into 4 amounts, 1 column of %50 of the figure, 30%, 6% etc. It's for my accounts so i know how much to put into different bank accounts.
I want it to display a number, not percentage. it's just the formula that uses a percentage. For ease, set all columns to divide the to 25% each for now. As long as it's easily editable.
Also - I want it to display the amount and yearly total amount for EACH column.
I want columns to put the date, what the job was, the employer and then the amount. Once i put in the amount it'll split it up into how much i should put into various accounts.
Landscape mode too and compatible with both excel and google sheets.
Please make it look clean, i hate a messy spreadsheet as I'm sure you do too. No preferences over font or colour scheme, i can sort that. I imagine if excel if your thing, this is pretty simple.
ASAP please. Thanks.
Matt K.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
67%
Last project
15 Jan 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Matt, if you can allocate this task today I could have it back to you within 1-2 hours? Are you prepared to do that?
153538
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies