Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
I have a formula in a cell (F17) that calculates the following: =B14/36
Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
use the round function: =ROUND(B14/36,0)
-- Brevity is the soul of wit. "Olle Svensson" wrote: I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
=ROUNDUP(B14/36,0)
Steve "Olle Svensson" wrote in message ... I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
Thanks but it does not work. I get the "You've entered too few arguments for
this formula" error. Any other ideas? "Dave F" wrote: use the round function: =ROUND(B14/36,0) -- Brevity is the soul of wit. "Olle Svensson" wrote: I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
=ROUNDUP(B14/36;0)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Olle Svensson" wrote in message ... I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to change number upwards.
That's the one, Bob. Thanks a bunch.
"Bob Phillips" wrote: =ROUNDUP(B14/36;0) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Olle Svensson" wrote in message ... I have a formula in a cell (F17) that calculates the following: =B14/36 Easy enough, it's just a normal formula. However, I would like the result to come out a bit different. Let's say that B14 = 300. That would (without decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this is where my problem comes in. See, I want the formula in F17 to display the next "whole" number if the answer is bigger than ,00. Like this: 300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would like it to display 21 instead. Do you understand and does anyone have a good solution? Thanks, Svensson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
If formula | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |