How to extract value from Excel function? Unicorn Meta Zoo #1: Why another podcast? ...
How to open locks without disable device?
Drawing a german abacus as in the books of Adam Ries
Bayes factor vs P value
What makes accurate emulation of old systems a difficult task?
How long after the last departure shall the airport stay open for an emergency return?
Why do games have consumables?
Why do distances seem to matter in the Foundation world?
A faster way to compute the largest prime factor
Is accepting an invalid credit card number a security issue?
Does Mathematica have an implementation of the Poisson binomial distribution?
When do you need buffers/drivers on buses in a microprocessor design?
Reattaching fallen shelf to wall?
Has a Nobel Peace laureate ever been accused of war crimes?
What is this word supposed to be?
Multiple fireplaces in an apartment building?
Do I need to protect SFP ports and optics from dust/contaminants? If so, how?
Contradiction proof for inequality of P and NP?
How can I wire a 9-position switch so that each position turns on one more LED than the one before?
Tikz positioning above circle exact alignment
A Paper Record is What I Hamper
Unable to completely uninstall Zoom meeting app
Raising a bilingual kid. When should we introduce the majority language?
Co-worker works way more than he should
As an international instructor, should I openly talk about my accent?
How to extract value from Excel function?
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraGetting the value in one column from a formula on another column in excelHow to add/subtract months from given date in ExcelHow can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?Representing Specific Data from a Dynamic Database (Array) in ExcelIn Excel, input values of one column based on value of anotherextract a phrase from excel cellExcel Compare Function / SoftwareSum value returned from function ExcelSort data with a functionFind adjacent values from a cell
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I would like to extract a value from an Excel function. I have a database of over 3000 entries, where each entry is given as a DATE function plus some value. Here is an example: "= DATE(2014; 7;1) + 0,0180555555555556".
Is there a neat way to subtract the second value over all the entries?
microsoft-excel worksheet-function
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I would like to extract a value from an Excel function. I have a database of over 3000 entries, where each entry is given as a DATE function plus some value. Here is an example: "= DATE(2014; 7;1) + 0,0180555555555556".
Is there a neat way to subtract the second value over all the entries?
microsoft-excel worksheet-function
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
You can use formulas for this. Look intoFIND, andLEFT
– cybernetic.nomad
21 hours ago
add a comment |
I would like to extract a value from an Excel function. I have a database of over 3000 entries, where each entry is given as a DATE function plus some value. Here is an example: "= DATE(2014; 7;1) + 0,0180555555555556".
Is there a neat way to subtract the second value over all the entries?
microsoft-excel worksheet-function
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I would like to extract a value from an Excel function. I have a database of over 3000 entries, where each entry is given as a DATE function plus some value. Here is an example: "= DATE(2014; 7;1) + 0,0180555555555556".
Is there a neat way to subtract the second value over all the entries?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
asked 21 hours ago
logingwithgooglelogingwithgoogle
1
1
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
logingwithgoogle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
You can use formulas for this. Look intoFIND, andLEFT
– cybernetic.nomad
21 hours ago
add a comment |
2
You can use formulas for this. Look intoFIND, andLEFT
– cybernetic.nomad
21 hours ago
2
2
You can use formulas for this. Look into
FIND, and LEFT– cybernetic.nomad
21 hours ago
You can use formulas for this. Look into
FIND, and LEFT– cybernetic.nomad
21 hours ago
add a comment |
2 Answers
2
active
oldest
votes
I use a US Locale, so in A1 I enter:
=DATE(2014,7,1)+0.0180555555555556
and in another cell:
=MID(FORMULATEXT(A1),FIND("+",FORMULATEXT(A1))+1,99)
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
add a comment |
Not sure if you want to extract or subtract the fractional part (you've used both terms in your question, and they are not the same.
Excel stores dates/times as days and fractions of a day. So:
To extract (return only the fractional part):
=MOD(DATE(2014; 7;1) + 0,0180555555555556;1)
To subtract (return only the integer part):
=INT(DATE(2014; 7;1) + 0,0180555555555556)
Or, you can just apply those functions to the cell containing the formula
In other words, if the formula is in A1:
=MOD(A1;1) will return (extract) the decimal value
=INT(A1) will return (subtract the decimal value) the integer value
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
logingwithgoogle is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429168%2fhow-to-extract-value-from-excel-function%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I use a US Locale, so in A1 I enter:
=DATE(2014,7,1)+0.0180555555555556
and in another cell:
=MID(FORMULATEXT(A1),FIND("+",FORMULATEXT(A1))+1,99)
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
add a comment |
I use a US Locale, so in A1 I enter:
=DATE(2014,7,1)+0.0180555555555556
and in another cell:
=MID(FORMULATEXT(A1),FIND("+",FORMULATEXT(A1))+1,99)
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
add a comment |
I use a US Locale, so in A1 I enter:
=DATE(2014,7,1)+0.0180555555555556
and in another cell:
=MID(FORMULATEXT(A1),FIND("+",FORMULATEXT(A1))+1,99)
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
I use a US Locale, so in A1 I enter:
=DATE(2014,7,1)+0.0180555555555556
and in another cell:
=MID(FORMULATEXT(A1),FIND("+",FORMULATEXT(A1))+1,99)
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
answered 18 hours ago
Gary's StudentGary's Student
14.3k31834
14.3k31834
add a comment |
add a comment |
Not sure if you want to extract or subtract the fractional part (you've used both terms in your question, and they are not the same.
Excel stores dates/times as days and fractions of a day. So:
To extract (return only the fractional part):
=MOD(DATE(2014; 7;1) + 0,0180555555555556;1)
To subtract (return only the integer part):
=INT(DATE(2014; 7;1) + 0,0180555555555556)
Or, you can just apply those functions to the cell containing the formula
In other words, if the formula is in A1:
=MOD(A1;1) will return (extract) the decimal value
=INT(A1) will return (subtract the decimal value) the integer value
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
add a comment |
Not sure if you want to extract or subtract the fractional part (you've used both terms in your question, and they are not the same.
Excel stores dates/times as days and fractions of a day. So:
To extract (return only the fractional part):
=MOD(DATE(2014; 7;1) + 0,0180555555555556;1)
To subtract (return only the integer part):
=INT(DATE(2014; 7;1) + 0,0180555555555556)
Or, you can just apply those functions to the cell containing the formula
In other words, if the formula is in A1:
=MOD(A1;1) will return (extract) the decimal value
=INT(A1) will return (subtract the decimal value) the integer value
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
add a comment |
Not sure if you want to extract or subtract the fractional part (you've used both terms in your question, and they are not the same.
Excel stores dates/times as days and fractions of a day. So:
To extract (return only the fractional part):
=MOD(DATE(2014; 7;1) + 0,0180555555555556;1)
To subtract (return only the integer part):
=INT(DATE(2014; 7;1) + 0,0180555555555556)
Or, you can just apply those functions to the cell containing the formula
In other words, if the formula is in A1:
=MOD(A1;1) will return (extract) the decimal value
=INT(A1) will return (subtract the decimal value) the integer value
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
Not sure if you want to extract or subtract the fractional part (you've used both terms in your question, and they are not the same.
Excel stores dates/times as days and fractions of a day. So:
To extract (return only the fractional part):
=MOD(DATE(2014; 7;1) + 0,0180555555555556;1)
To subtract (return only the integer part):
=INT(DATE(2014; 7;1) + 0,0180555555555556)
Or, you can just apply those functions to the cell containing the formula
In other words, if the formula is in A1:
=MOD(A1;1) will return (extract) the decimal value
=INT(A1) will return (subtract the decimal value) the integer value
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
answered 12 hours ago
Ron RosenfeldRon Rosenfeld
2,1242611
2,1242611
add a comment |
add a comment |
logingwithgoogle is a new contributor. Be nice, and check out our Code of Conduct.
logingwithgoogle is a new contributor. Be nice, and check out our Code of Conduct.
logingwithgoogle is a new contributor. Be nice, and check out our Code of Conduct.
logingwithgoogle is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429168%2fhow-to-extract-value-from-excel-function%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
You can use formulas for this. Look into
FIND, andLEFT– cybernetic.nomad
21 hours ago