Some excel formulas needed
- or -
Post a project like this1911
£40(approx. $50)
- Posted:
- Proposals: 1
- Remote
- #2251747
- Awarded
Description
Experience Level: Entry
Formulas.
I want to adapt existing information in an excel sheet. this sheet has various information place in columns.
I need to create formulas for the below. These can be placed in the adjoining column (ie insert a column next to the existing data on insert a formula based a cell in another column )
1 if there are 4 digits in a cell return 1st digit OR if 5 characters in a cell return the first 2 digits
if the number is 8000 (4 digits) I want the formula show “8” so the 1st digit in a string of 4 digits
if the number is 16000 (5 digits) I want the formula show “16” so the 1st & 2nd digits in a string of 5 digits
so 8000 would become 8 & 15000 would become 15 etc
2 if the word "none" appears I want to show "NB" if anything there is anything else in the cell I want to show a blank (empty) cell
3 if the 1st 2 characters in a cell are US I want to show "U" if anything else I want to show a blank (empty) cell
4 if there is any data in a cell I want to show "-" if no data I want to show a blank (empty) cell
I want to adapt existing information in an excel sheet. this sheet has various information place in columns.
I need to create formulas for the below. These can be placed in the adjoining column (ie insert a column next to the existing data on insert a formula based a cell in another column )
1 if there are 4 digits in a cell return 1st digit OR if 5 characters in a cell return the first 2 digits
if the number is 8000 (4 digits) I want the formula show “8” so the 1st digit in a string of 4 digits
if the number is 16000 (5 digits) I want the formula show “16” so the 1st & 2nd digits in a string of 5 digits
so 8000 would become 8 & 15000 would become 15 etc
2 if the word "none" appears I want to show "NB" if anything there is anything else in the cell I want to show a blank (empty) cell
3 if the 1st 2 characters in a cell are US I want to show "U" if anything else I want to show a blank (empty) cell
4 if there is any data in a cell I want to show "-" if no data I want to show a blank (empty) cell
Gary L.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
40%
Last project
29 Dec 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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