Combining Formulas add percent and roundup
up vote
0
down vote
favorite
How can I combine the following formulas?
=f4*0.54
and
=roundup(d4,0)
In cell D4
I have the formula =f4*0.54
, which gives me our cost from an MSRP cost that I entered in cell F4
, but the cost that shows in D4
ends up being 137.11, I'd like it to just round up to 138.00.
microsoft-excel worksheet-function combine
add a comment |
up vote
0
down vote
favorite
How can I combine the following formulas?
=f4*0.54
and
=roundup(d4,0)
In cell D4
I have the formula =f4*0.54
, which gives me our cost from an MSRP cost that I entered in cell F4
, but the cost that shows in D4
ends up being 137.11, I'd like it to just round up to 138.00.
microsoft-excel worksheet-function combine
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
How can I combine the following formulas?
=f4*0.54
and
=roundup(d4,0)
In cell D4
I have the formula =f4*0.54
, which gives me our cost from an MSRP cost that I entered in cell F4
, but the cost that shows in D4
ends up being 137.11, I'd like it to just round up to 138.00.
microsoft-excel worksheet-function combine
How can I combine the following formulas?
=f4*0.54
and
=roundup(d4,0)
In cell D4
I have the formula =f4*0.54
, which gives me our cost from an MSRP cost that I entered in cell F4
, but the cost that shows in D4
ends up being 137.11, I'd like it to just round up to 138.00.
microsoft-excel worksheet-function combine
microsoft-excel worksheet-function combine
edited Nov 27 at 22:35
Worthwelle
2,2593824
2,2593824
asked Nov 27 at 19:46
user967695
12
12
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32
add a comment |
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
Like Andrew said, you can place the multiplication formula within the =ROUNDUP
formula.
Something like=ROUNDUP((F4*0.54),0)
would do the trick.
add a comment |
up vote
0
down vote
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54
is in D4
, you replace the D4
in =roundup(D4,0)
with everything except the =
(f4*0.54
).
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
Like Andrew said, you can place the multiplication formula within the =ROUNDUP
formula.
Something like=ROUNDUP((F4*0.54),0)
would do the trick.
add a comment |
up vote
1
down vote
Like Andrew said, you can place the multiplication formula within the =ROUNDUP
formula.
Something like=ROUNDUP((F4*0.54),0)
would do the trick.
add a comment |
up vote
1
down vote
up vote
1
down vote
Like Andrew said, you can place the multiplication formula within the =ROUNDUP
formula.
Something like=ROUNDUP((F4*0.54),0)
would do the trick.
Like Andrew said, you can place the multiplication formula within the =ROUNDUP
formula.
Something like=ROUNDUP((F4*0.54),0)
would do the trick.
answered Nov 27 at 22:41
Jacob
113
113
add a comment |
add a comment |
up vote
0
down vote
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54
is in D4
, you replace the D4
in =roundup(D4,0)
with everything except the =
(f4*0.54
).
add a comment |
up vote
0
down vote
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54
is in D4
, you replace the D4
in =roundup(D4,0)
with everything except the =
(f4*0.54
).
add a comment |
up vote
0
down vote
up vote
0
down vote
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54
is in D4
, you replace the D4
in =roundup(D4,0)
with everything except the =
(f4*0.54
).
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54
is in D4
, you replace the D4
in =roundup(D4,0)
with everything except the =
(f4*0.54
).
answered Nov 27 at 22:44
Worthwelle
2,2593824
2,2593824
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1378868%2fcombining-formulas-add-percent-and-roundup%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
Which formula is in which cell?
– Scott Craner
Nov 27 at 19:54
Combine them in what way? Please show the original cell contents, describe what you want to accomplish with them, and what the contents should be when you're done.
– fixer1234
Nov 27 at 19:58
When you say combine, are you looking for something like "=roundup(f4*0.54,0)" so that it multiplies f4 by 0.54 and rounds up without needing a new cell for the roundup formula?
– Andrew
Nov 27 at 20:13
I wish I could show snip, I'm no good at excel... so, in cell D4 I have the formula =f4*0.54, which gives me our cost from an msrp cost that I entered in cell f4, but the cost that shows in D4 ends up being 137.11, I'd like it to just round up to 138.00
– user967695
Nov 27 at 20:32