Multiply cells in Excel if a cell has a more recent date
I am currently building an Excel worksheet for managing inventory in a large kitchen and I would like to find the value of the inventory for the most recent day.
Inventory is taken four days a week and each row in the table has a price value. What I am trying to do is multiply the inventory for the most recent day in the row.
So if I put in 6 for MON then the value would update to 58.80.
If I add 4 in TUE then the value would change to 39.20.
The way I have it set now, it just adds up all the values MON through THU and doesn't give me a daily calculation.
microsoft-excel
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
add a comment |
I am currently building an Excel worksheet for managing inventory in a large kitchen and I would like to find the value of the inventory for the most recent day.
Inventory is taken four days a week and each row in the table has a price value. What I am trying to do is multiply the inventory for the most recent day in the row.
So if I put in 6 for MON then the value would update to 58.80.
If I add 4 in TUE then the value would change to 39.20.
The way I have it set now, it just adds up all the values MON through THU and doesn't give me a daily calculation.
microsoft-excel
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
add a comment |
I am currently building an Excel worksheet for managing inventory in a large kitchen and I would like to find the value of the inventory for the most recent day.
Inventory is taken four days a week and each row in the table has a price value. What I am trying to do is multiply the inventory for the most recent day in the row.
So if I put in 6 for MON then the value would update to 58.80.
If I add 4 in TUE then the value would change to 39.20.
The way I have it set now, it just adds up all the values MON through THU and doesn't give me a daily calculation.
microsoft-excel
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
I am currently building an Excel worksheet for managing inventory in a large kitchen and I would like to find the value of the inventory for the most recent day.
Inventory is taken four days a week and each row in the table has a price value. What I am trying to do is multiply the inventory for the most recent day in the row.
So if I put in 6 for MON then the value would update to 58.80.
If I add 4 in TUE then the value would change to 39.20.
The way I have it set now, it just adds up all the values MON through THU and doesn't give me a daily calculation.
microsoft-excel
microsoft-excel
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
edited Dec 23 '18 at 12:00
fixer1234
18.4k144781
18.4k144781
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
asked Dec 22 '18 at 23:00
davidxd33davidxd33
11619
11619
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
There is a trick to finding the last non-empty cell in a range. It is documented here.
Assuming your price is in cell D1 and the four inventory numbers are in H2:K2, you can calculate the last inventory value with this formula:
=D2*LOOKUP(2,1/(H2:K2<>""),H2:K2)
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
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
});
}
});
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%2f1387021%2fmultiply-cells-in-excel-if-a-cell-has-a-more-recent-date%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is a trick to finding the last non-empty cell in a range. It is documented here.
Assuming your price is in cell D1 and the four inventory numbers are in H2:K2, you can calculate the last inventory value with this formula:
=D2*LOOKUP(2,1/(H2:K2<>""),H2:K2)
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
add a comment |
There is a trick to finding the last non-empty cell in a range. It is documented here.
Assuming your price is in cell D1 and the four inventory numbers are in H2:K2, you can calculate the last inventory value with this formula:
=D2*LOOKUP(2,1/(H2:K2<>""),H2:K2)
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
add a comment |
There is a trick to finding the last non-empty cell in a range. It is documented here.
Assuming your price is in cell D1 and the four inventory numbers are in H2:K2, you can calculate the last inventory value with this formula:
=D2*LOOKUP(2,1/(H2:K2<>""),H2:K2)
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
There is a trick to finding the last non-empty cell in a range. It is documented here.
Assuming your price is in cell D1 and the four inventory numbers are in H2:K2, you can calculate the last inventory value with this formula:
=D2*LOOKUP(2,1/(H2:K2<>""),H2:K2)
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
answered Dec 22 '18 at 23:36
BlackwoodBlackwood
2,88861728
2,88861728
add a comment |
add a comment |
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%2f1387021%2fmultiply-cells-in-excel-if-a-cell-has-a-more-recent-date%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
