Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup to Return a Range of Data Rob Excel Discussion (Misc queries) 13 June 1st 06 04:02 AM
If formula John Excel Worksheet Functions 4 May 17th 06 04:42 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 06:30 AM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 02:57 AM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"