Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Calculation Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Round only rounds to the number of digits you specify, not to a particular
increment.

If you wanted 1044.333 to round to 1045 (or anything else besides 1044.33),
the round function won't do that but ceiling will.

ceiling(1044.333333,1)=1045

ceiling(1044.333333,0.5)=1044.5

ceiling(1044.333333,3/12)=1044.5

ceiling(1044.33333,8)=1048 (block module)

etc.

"Ceiling" (and "floor") are much more powerful than "round" with the same
number of keystrokes.

T. William (Bill) Allen, S.E. (CA #2607)	
ALLEN DESIGNS	
Consulting Structural Engineers	
http://www.AllenDesigns.com	

-----Original Message-----
From: Markajohn(--nospam--at)cs.com [mailto:Markajohn(--nospam--at)cs.com] 
Sent: Tuesday, July 13, 2004 1:54 PM
To: seaint(--nospam--at)seaint.org
Subject: Re: Calculation Software

In a message dated 7/13/04 1:47:34 PM Pacific Daylight Time, 
T.W.Allen(--nospam--at)cox.net writes:

> One problem with concatenation is that the result is text. So, if cell B3
>  calculates to 1044.33333333333333 

That's why you use the "round" function.  round(1044.33333333,2) displays as

1044.33.

MJ


******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ******** 



******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********