[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: ROUND function - How to RoundUp ?



PureBytes Links

Trading Reference Links

perfect
--- In amibroker@xxxxxxxxxxxxxxx, Dennis Brown <see3d@xxx> wrote:
>
> Look at ceil() and also floor() for the inverse.
> 
> BR,
> Dennis
> 
> 
> On Apr 21, 2009, at 12:51 PM, gmorlosky wrote:
> 
> > What is a an easy way to RoundUp, instead of just Round ?
> > I take the square root of a number (say 85) and then it's square  
> > root (9.2) and then round (9) to create a square matrix (total of  
> > 81), which comes up short by 4 cells.
> > How can I RoundUp ?
> >
> > Here's my formula:
> > NumRowColumn = IIf(round(sqrt(CountAll))>16,16,round(sqrt(CountAll)));
> >
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/